闪回命令出错 ORA-08189: cannot flashback the table because row movement is not enabled

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.

 

闪回成功