00063.Oracle默认临时表空间设置

 

SQL>  select * from database_properties where property_name like 'DEFAULT%';

 

PROPERTY_NAME             PROPERTY_VALUE   DESCRIPTION

------------------------- ---------------- --------------------------------------

DEFAULT_TEMP_TABLESPACE   TEMP             Name of default temporary tablespace

DEFAULT_PERMANENT_TABLESP USERS            Name of default permanent tablespace

ACE

 

DEFAULT_EDITION           ORA$BASE         Name of the database default edition

DEFAULT_TBS_TYPE          SMALLFILE        Default tablespace type

SQL> alter database default temporary tablespace test_temp;

 

Database altered.

SQL>  select * from database_properties where property_name like 'DEFAULT%';

 

PROPERTY_NAME             PROPERTY_VALUE   DESCRIPTION

------------------------- ---------------- --------------------------------------

DEFAULT_TEMP_TABLESPACE   TEST_TEMP        Name of default temporary tablespace

DEFAULT_PERMANENT_TABLESP USERS            Name of default permanent tablespace

ACE

 

DEFAULT_EDITION           ORA$BASE         Name of the database default edition

DEFAULT_TBS_TYPE          SMALLFILE        Default tablespace type