查看 drop的表
1.show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TEST_PURGE BIN$op097VdeQwKNHTBVCa/23w==$0 TABLE 2009-03-31:19:04:10
1.2.闪回
flashback table test_purge to before drop;
2。查看闪回条件,闪回查询
show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- -----------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
1.show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TEST_PURGE BIN$op097VdeQwKNHTBVCa/23w==$0 TABLE 2009-03-31:19:04:10
1.2.闪回
flashback table test_purge to before drop;
2。查看闪回条件,闪回查询
show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- -----------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1