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

SQL> flashback table fb_table to timestamp

  2 to_date('2014-05-17 15:25:44','yyyy-mm-dd hh24:mi:ss');

flashback table fb_table to timestamp

                *

ERROR at line 1:

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

启用表允许行移动

alter  table fb_table enable row movement;

Table altered.

SQL> select table_name,row_movement from user_tables

  2 where table_name='FB_TABLE';

TABLE_NAME ROW_MOVE

------------------------------ --------

FB_TABLE ENABLED

SQL> flashback table fb_table to timestamp to_date('2014-05-17 15:41:01',

  2 'yyyy-mm-dd hh24:mi:ss');

Flashback complete.