flashback table 命令使用

1.alter table ** enable row movement
2.确定SCN
 select versions_xid,versions_startscn,versions_endscn, 

 decode(versions_operation,'I','INSERT','U','UPDATE','D','DELETE','ORIGINAL') "OPERATION", 

 ID,NAME 

 FROM DEP 

 VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE 

WHERE ID=1;
3.不断尝试
flashback table ** to scn **;