SELECT * FROM MEM_PACKAGE AS OF TIMESTAMP TO_TIMESTAMP('2015-06-16 14:30:00', 'YYYY-MM-DD HH24:MI:SS');
--使用闪回查询还原丢失的行
INSERT INTO MEM_PACKAGE (SELECT * FROM MEM_PACKAGE AS OF TIMESTAMP TO_TIMESTAMP('2015-06-16 14:30:00', 'YYYY-MM-DD HH24:MI:SS'));
转载于:https://my.oschina.net/liu13430/blog/467489