While doing flashback on a table, got below error:
17:13:10 SQL> flashback table dbaclass.DEP_TAB to timestamp sysdate – 1/144;
flashback table dbaclass.DEP_TAB to timestamp sysdate – 1/144
*
ERROR at line 1:
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='DEP_TAB' TABLE_NAME ROW_MOVE ----------------------- -------- DEP_TAB DISABLED SQL> alter table dbaclass.DEP_TAB enable row movement; Table altered. SQL> select table_name,ROW_MOVEMENT from dba_tables where table_name='DEP_TAB'; TABLE_NAME ROW_MOVE ----------------------- -------- DEP_TAB ENABLED
Now run flashback again.
17:22:20 SQL> flashback table dbaclass.DEP_TAB to timestamp sysdate - 1/144; Flashback complete.