1. 恢复数据
alter table dyna_DRP_NumberPool enable row movement; //允许行移动
flashback table dyna_DRP_NumberPool TO TIMESTAMP TO_TIMESTAMP('2014-02-07 10:00:00', 'YYYY-MM-DD HH:MI:SS');
alter table dyna_DRP_NumberPool disable row movement;
2. 查询以前的数据
SELECT * FROM TABLENAME AS OF TIMESTAMP TO_TIMESTAMP ('2003-04-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');