test@ORCL>flashback table t to scn:scn
2 ;
flashback table t to scn:scn
*
ERROR at line 1:
ORA-08189: cannot flashback the table because row movement is not enabled
使用闪回命令出错
test@ORCL>select row_movement from user_tables where table_name='T';
ROW_MOVE
--------
DISABLED
表行迁移开关未打开
test@ORCL>alter table t enable row movement;
Table altered.
开启行迁移
test@ORCL>flashback table t to scn:scn;
Flashback complete.
闪回成功