当前位置: DBARoad > 基础知识 > 文章正文

SQL> drop tablespace temp01 including contents and datafiles;  
drop tablespace temp01 including contents and datafiles
*
ERROR at line 1:
ORA-12906: cannot drop default temporary tablespace
 
SQL> select username,temporary_tablespace from dba_users;
 
USERNAME                       TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYS                            TEMP01
SYSTEM                         TEMP01
DBSNMP                         TEMP01
SQLTXPLAIN                     TEMP01
PERFSTAT                       TEMP01
OUTLN                          TEMP01
WMSYS                          TEMP01
 
7 rows selected.
 
SQL> CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
  2  'D:\ORACLE\ORADATA\SKY\TEMP01.DBF' SIZE 41943040 autoextend off;
 
Tablespace created.
 
SQL> alter database default temporary tablespace temp;
 
Database altered.
 
SQL> select username,temporary_tablespace from dba_users;
 
USERNAME                       TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYS                            TEMP
SYSTEM                         TEMP
DBSNMP                         TEMP
SQLTXPLAIN                     TEMP
PERFSTAT                       TEMP
OUTLN                          TEMP
WMSYS                          TEMP
 
7 rows selected.

SQL> drop tablespace temp01 including contents and datafiles;
 
Tablespace dropped.