误删表及数据恢复

===========================回滚表中数据===========================
-- 1.启用行移动功能
alter table table_name enable row movement;
-- 2.回滚数据
flashback table table_name to timestamp to_timestamp('2019-01-01 13:00:00','yyyy-mm-dd hh24:mi:ss');

============================误删表恢复===========================
--查看最近删除的表
select object_name,original_name,createtime,droptime from recyclebin a where a.original_name='FSM_FUND_TRANS_FLOW';
--恢复误删除的表
flashback table "BIN$mgQb8tlRLB7gVGpah0k6AA==$0" to before drop;

上一篇:【OCP最新题库解析(052)--题21】Table EMP resides in the USERS tablespace.


下一篇:Oracle 闪回查询权限