SQL> select * from v$tablespace;
TS# NAME INC
---------- ------------------------------ ---
0 SYSTEM YES
1 UNDOTBS1 YES
9 USERS YES
2 TEMP YES
3 CWMLITE YES
4 DRSYS YES
5 EXAMPLE YES
6 INDX YES
7 ODM YES
8 TOOLS YES
10 XDB YES
已选择11行。
SQL> drop tablespace cwmlite
2 ;
drop tablespace cwmlite
*
ERROR 位于第 1 行:
ORA-01549: 表空间非空,请使用 INCLUDING CONTENTS 选项
SQL> drop tablespace cwmlite including contents;
表空间已丢弃。
SQL> select * from v$tablespace;
TS# NAME INC
---------- ------------------------------ ---
0 SYSTEM YES
1 UNDOTBS1 YES
9 USERS YES
2 TEMP YES
4 DRSYS YES
5 EXAMPLE YES
6 INDX YES
7 ODM YES
8 TOOLS YES
10 XDB YES
已选择10行。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12778571/viewspace-178852/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12778571/viewspace-178852/