oracle中误删除表后恢复语句(FLASHBACK)

486 查看

复制代码 代码如下:

select * from dba_recyclebin;
select * from user_recyclebin;
FLASHBACK TABLE CF_IMPORT_RULE TO BEFORE DROP;
FLASHBACK COMPLETE