ANBOB™

开启了recycle功能，删除的表会放到recyclebin中除sys,system,储存在对象原所在表空间，除了外键约束外，表的其它表附加对象还可以闪回，但如果一个表空间中的所有对象都已在recyclebin中，该表空间可以删除么？需要INCLUDING CONTENTS么？

SQL> create tablespace testdrop datafile '/oradata/orcl/testdrop.dbf' size 2m;
Tablespace created.

SQL> create table anbob.testdr (id int) tablespace testdrop;
Table created.

SQL> insert into anbob.testdr values(1);
1 row created.

SQL> commit;
Commit complete.
SQL> select table_name,tablespace_name,owner from dba_tables where table_name='TESTDR';

TABLE_NAME                     TABLESPACE_NAME                OWNER
------------------------------ ------------------------------ ------------------------------
TESTDR                         TESTDROP                       ANBOB

SQL> drop table anbob.testdr;
Table dropped.

SQL> select owner,object_name,original_name from dba_recyclebin;

OWNER                          OBJECT_NAME                    ORIGINAL_NAME
------------------------------ ------------------------------ --------------------------------
ANBOB                          BIN$rEMy9J9X1FvgQAB/AQAMUQ==$0 TESTDR

SQL> drop tablespace testdrop;

Tablespace dropped.

SQL> select owner,object_name,original_name from dba_recyclebin;

可以看到毫无提示的把表空间删除，而且回收站的东西也跟随而去！

打赏

微信扫一扫，打赏作者吧～