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.

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google