oracle Temp 管理(三)

2014-11-24 11:46:47 · 作者: · 浏览: 3
TEMP

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