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 **;