错误删除数据或清空数据怎样可以找回

此方法好用

select * from 表名 as of timestamp sysdate-1;

上面不行请用下面的语句

select * from store_record as of timestamp sysdate-1/24/60*40;

--开启行移动功能
alter table sys_function enable row movement;
--恢复表数据
flashback table sys_function to timestamp to_timestamp('2015-12-17 09:40:00','yyyy-mm-dd hh24:mi:ss');
上述时间为删除数据的时间
备注：恢复后请关闭行移动功能


select * from sys_function as of timestamp to_timestamp('2011-12-09 10:00:00','yyyy-mm-dd hh24:mi:ss');



可以这样做：
alter table sys_function enable row movement;
flashback table sys_function to timestamp to_timestamp('2015-12-07 9:00:00','yyyy-mm-dd HH24:MI:SS');
以上就是需要回滚到某一日期的方法！




1: select  object_name from User_Recyclebin where original_name='TUSER';
2：create table TUSER_2 as select *from "上面查到的object name";
现在你试试看