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

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