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

ANKUSH THAVALI
15 Dec, 2023
0 Comments
1 Min Read

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

While permorming flashback on a table, got this error:

Solution: 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.