oracle应用之数据恢复

--查询回收站里面的对象
SELECT * FROM USER_RECYCLEBIN T WHERE T.original_name = 'BK160106_SP_SS_TASK_SURVE_209'
--恢复删除的表
FLASHBACK TABLE BK160106_SP_SS_TASK_SURVE_209 TO BEFORE DROP;
--查询误删除的数据
SELECT * FROM FLASHBACK_TRANSACTION_QUERY Q WHERE Q.table_name='';
--根据时间恢复数据
SELECT * FROM SP_SS_ACCIDENT_REPORT AS OF TIMESTAMP TO_TIMESTAMP('2009-12-11 20:47:30','yyyy-mm-dd hh24:mi:ss');
--恢复表某个时间段的数据
FLASHBACK TABLE SP_SS_ACCIDENT_REPORT TO TIMESTAMP TO_TIMESTAMP('2009-12-11 20:47:30','yyyy-mm-dd hh24:mi:ss');\