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

Error Description:
Flashback table command failed with following error.
SQL> FLASHBACK TABLE test2 TO TIMESTAMP TO_TIMESTAMP('2013-10-28 12:00:00', 'YYYY-MM-DD HH24:MI:SS');
FLASHBACK TABLE test2 TO TIMESTAMP TO_TIMESTAMP('2013-10-28 12:00:00', 'YYYY-MM-DD HH24:MI:SS')
                *
ERROR at line 1:
ORA-08189: cannot flashback the table because row movement is not enabled

Solution Description:
        All flashback related operation on any oracle table requires the row movement enablement on the particular table. Below mentioned are the flashback related operations can be performed and which need the row movement enabled.
·        Flashback table
·        Flashback transaction query
·        Flashback version query
Here is the command to enable the row movement.
Syntax: alter table enable row movement;

Example:

SQL> alter table test2 enable row movement;


Table altered.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google