关于CREATE TABLESPACE USERS;

98. View this parameter setting in your database:
DB_CREATE_FILE_DEST='D:\oracle\product\10.2.0\oradata\oracle'
You created a tablespace by using this command:
CREATE TABLESPACE USERS;
Which two statements are true about the USERS tablespace? (Choose two.)
A. The tablespace has two data files.
B. An error is reported and tablespace creation fails.
C. Data files are created with names generated by the instance.
D. The tablespace can be extended without specifying the data file.
E. Data files belonging to the USERS tablespace cannot be renamed.
Answer: CD

按照题目的条件创建USER表空间报错了，为啥答案还是CD呢？

SQL> alter system set DB_CREATE_FILE_DEST='/u01/app/oracle/oradata/pdb/' scope=both;

System altered.

SQL> create tablespace users;
create tablespace users
*
ERROR at line 1:
ORA-01543: tablespace 'USERS' already exists

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21126685/viewspace-670710/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21126685/viewspace-670710/