你可能已经知道,可以删除只读表空间中的表。
SQL> create tablespace test datafile '/u01/app/oracle/oradata/ZWC/test01.dbf' size 10M;
Tablespace created.
SQL> alter tablespace test read only;
Tablespace altered.
SQL> alter tablespace test read write;
Tablespace altered.
SQL> create table t_zhongwc tablespace test as select * from all_users;
Table created.
SQL> alter tablespace test read only;
Tablespace altered.
SQL> drop table t_zhongwc;
Table dropped.
在只读表空间中删除了一个表,我们查询dba_segments
SQL> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
T_ZHONGWC BIN$1H4r7lVyMwHgQ8kBqMCtkg==$0 TABLE 2013-01-30:16:19:39
SQL> select owner,segment_name,segment_type from dba_segments where tablespace_name = 'TEST';
OWNER SEGMENT_NAME SEGMENT_TYPE
----- ----------------------------------- --------------------
SYS BIN$1H4r7lVyMwHgQ8kBqMCtkg==$0 TABLE
清除回收站,试图把表真正删除
SQL> purge recyclebin;
Recyclebin purged.
SQL> select owner,segment_name,segment_type from dba_segments where tablespace_name = 'TEST';
OWNER SEGMENT_NAME SEGMENT_TYPE
----- ----------------------------------- --------------------
SYS 6.130 TEMPORARY