误删oracle数据恢复(闪回查询)
闪回后,把删除的表,及索引都会恢复
- flashback table t1 to before drop;
flashback table t1 to before drop;
闪回到某时间点
- select * from t asoftimestamp to_timestamp('2012-06-29 22:57:47', 'yyyy-mm-dd hh24:mi:ss');
闪回后,把删除的表,及索引都会恢复
flashback table t1 to before drop;
闪回到某时间点