ORA-08189: Cannot Flashback The Table Because Row Movement Is Not Enabled

Question

OracleDba · Accepted Answer

To flashback a table, we need to enable row movement.

select table_name,ROW_MOVEMENT from dba_tables where table_name='DEPT'

TABLE_NAME ROW_MOVE

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

DEPT DISABLED

SQL> alter table dbaclass.DEPT enable row movement;

Table altered.

SQL> select table_name,ROW_MOVEMENT from dba_tables where table_name='DEPT';

TABLE_NAME ROW_MOVE

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

DEPT ENABLED

Now run flashback again.

flashback table dbaclass.DEPT to timestamp sysdate - 1;

Flashback complete.

Solutions(1)