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

advertisements

_____________________________________________________________________________________________________________________

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.

_____________________________________________________________________________________________________________________

Website Stats