路虽弥，不行不至；事虽少，不做不成。
分类： Oracle
2013-07-13 17:01:22
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')
