闪回命令出错 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.

 

闪回成功