闪回表（version)查询

闪回表的版本查询

1.定位表的闪回目标SCN号

SELECT versions_xid XID, versions_startscn START_SCN,
  versions_endscn END_SCN, versions_operation OPERATION,
  REGION_ID,REGION_NAME
FROM REGIONS 
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE;

HR@PROD1>select * from regions as of scn 1257307;

2.开启行移动

alter table regions enable row movement;

3.闪回表到指定SCN

flashback table regions to scn 1257307;

下面是 regions,COUNTRIES,LOCATIONS三个表存在外键关联关系,按实际情况考虑上表同时闪回
flashback table regions,COUNTRIES,LOCATIONS to scn 1257307;