ORA-08189: cannot flashback the table because row movement is not enabled

SQL> flashback table a TO TIMESTAMP SYSTIMESTAMP - INTERVAL '2' MINUTE;
flashback table a TO TIMESTAMP SYSTIMESTAMP - INTERVAL '2' MINUTE
                *
ERROR at line 1:
ORA-08189: cannot flashback the table because row movement is not enabled
 

查看表有没有启用　row movement ：

15:58:17 SQL> select row_movement from user_tables where table_name='A';  

ROW_MOVE
--------
DISABLED

 

开启row movement:

15:58:23 SQL> alter table a enable row movement;

Table altered.

15:59:53 SQL> select row_movement from user_tables where table_name='A';

ROW_MOVE
--------
ENABLED

 

禁用　row movement：

16:01:03 SQL> alter table a disable row movement;

Table altered.

16:02:28 SQL> select row_movement from user_tables where table_name='A';

ROW_MOVE
--------
DISABLED

16:04:51 SQL> flashback table a TO TIMESTAMP SYSTIMESTAMP - INTERVAL '5' minute;

Flashback complete.