闪回误删除的表

情景描述：用户误 drop table 操作。
--查看测试表及数据
SQL> select * from test;

        ID NAME
---------- --------------------
         1 yallonking
         2 yallonking
         3 yallonking
         4 oraking
         5 oraking
         6 oraking

6 rows selected.
--创建索引
SQL> create index idx_test on test(id);

Index created.
--模拟删除表
SQL> drop table test;

Table dropped.
--查看表是否存在
SQL> select * from test;
select * from test
              *
ERROR at line 1:
ORA-00942: table or view does not exist
--查看当前用户关于被删除表的相关对象信息
SQL> select object_name,object_type from user_objects where object_name='TEST';

no rows selected

SQL> select constraint_name,constraint_type,table_name from user_constraints where table_name='TEST';

no rows selected
--查看当前用户回收站中是否存在误删除表的相关对象
SQL> select object_name,original_name,type from user_recyclebin;

OBJECT_NAME                    ORIGINAL_NAME
------------------------------ --------------------------------
TYPE
-------------------------
BIN$r/evIsbKcv3gQKjAgDsIEw==$0 TEST_2010
Table Partition

BIN$vMgUYu1Ly3PgQKjAYwEH1Q==$0 IDX_TEST
INDEX

BIN$vMgUYu1My3PgQKjAYwEH1Q==$0 TEST
TABLE
--闪回误删除的表
SQL> flashback table test to before drop;

Flashback complete.
--恢复因删除表失效的索引
SQL> alter index "BIN$vMgUYu1Ly3PgQKjAYwEH1Q==$0" rename to idx_test;

Index altered.
--查看恢复后表数据
SQL> select * from test;

        ID NAME
---------- --------------------
         1 yallonking
         2 yallonking
         3 yallonking
         4 oraking
         5 oraking
         6 oraking

6 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26143577/viewspace-720310/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26143577/viewspace-720310/