数据库 flashback

查看　drop的表

１.show recyclebin
ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
TEST_PURGE       BIN$op097VdeQwKNHTBVCa/23w==$0 TABLE        2009-03-31:19:04:10

１.２.闪回
flashback table test_purge to before drop;

２。查看闪回条件，闪回查询
show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- -----------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1