ORACLE 9及以上版本闪回,误删除恢复
1)需要开户flashback功能
select flashback_on from v$database
flashback table TEST to timestamp to_Date('2013-07-13 16:08:00', 'yyyy-mm-dd hh24:mi:ss')
或
flashback table TEST to timestamp to_timestamp('2013-07-13 16:08:00','yyyy-mm-dd hh24:mi:ss');
2)不需要开户flashback功能
INSERT INTO TEST SELECT * FROM TEST AS OF TIMESTAMP to_Date('2013-07-13 16:08:00', 'yyyy-mm-dd hh24:mi:ss')
或
INSERT INTO TEST SELECT * FROM TEST AS OF TIMESTAMP to_timestamp('2013-07-13 16:50:00', 'yyyy-mm-dd hh24:mi:ss')