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行。