Oracled10g表级、行级闪回示例

 delete from classinfo
 where classid='990713';
Commit;
1.确保激活表的Row Movement特征
 alter table classinfo enable row movement;
2.执行数据表行闪回
 flashback table classinfo to timestamp to_timestamp
 ('2008-02-21 21:30:30','YYYY-MM-DD HH24:MI:SS');
--表级闪回
drop table classinfo;
Flashback table classinfo before drop;