You created a new user in your database but missed assigning a default tablespace to that user. The
user created a table without specifying the tablespace name. In which tablespace would the table be
stored?
A.
the INDEX tablespace
B.
the USERS tablespace
C.
the SYSAUX tablespace
D.
the SYSTEM tablespace
E.
the default undo tablespace
F.
the default temporary tablespace
G.
the default permanent tablespace
find default permanent tablespace
SQL> SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME = ‘DEFAULT_PERMANENT_TABLESPACE
SET DEFAULT PERMANENT TABLESPACE
First, make sure that you have created a permanent tablespace.
Next you will need to change the Oracle database to use your permanent tablespace as the default permanent tablespace.
To set the default permanent tablespace in Oracle, you can run the following ALTER DATABASE statement:
Permanent tablespaces are used to store user data and user created objects like tables, indexes and materialized views. Sample create statements:
CREATE TABLESPACE tools DATAFILE ‘/u01/oradata/orcl/tools/file_1.dbf’ SIZE 100M;
CREATE TABLESPACE tools DATAFILE ‘C:\ORA\tools01.dbf’ SIZE 100M AUTOEXTEND ON MAXSIZE 500M;