OCP TEMP
TEST1 TEMP
OUTLN TEMP
MDSYS TEMP
ORDSYS TEMP
CTXSYS TEMP
ANONYMOUS TEMP
EXFSYS TEMP
DMSYS TEMP
WMSYS TEMP
XDB TEMP
ORDPLUGINS TEMP
SI_INFORMTN_SCHEMA TEMP
OLAPSYS TEMP
USERNAME TEMPORARY_TABLESPACE
------------------------------ ------------------------------
MDDATA TEMP
DIP TEMP
TSMSYS TEMP
23 rows selected
--删除中转临时表空间temp2
SQL> drop tablespace temp2 including contents and datafiles;
Tablespace dropped
摘自 Laughing