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')

 

10-28 02:12