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

Answers were Sorted based on User's Feedback



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

Answer / sdsd

suppose if u delete 2 tables in the flashback process after that u need to alter both 2 tables row movement other wise u will get this error

Is This Answer Correct ?    1 Yes 0 No

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

Answer / guest

Cause: An attempt was made to perform Flashback Table
operation on a table for which row movement has not been
enabled. Because the Flashback Table does not preserve the
rowids, it is necessary that row movement be enabled on the
table.

Action: Enable row movement on the table

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00528: The parameters to an ORDER function must have IN mode

1 Answers  


ORA-31490: could not attach to LogMiner session

1 Answers  


ORA-24338: statement handle not executed

1 Answers  


RMAN-06067: RECOVER DATABASE required with a backup or created controlfile

1 Answers  


DRG-50935: parser component failure

1 Answers  






ORA-30367: a JOIN KEY clause is required

1 Answers  


PLS-00311: the declaration of "string" is incomplete or malformed

2 Answers  


ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

1 Answers  


ORA-27486: insufficient privileges

1 Answers  


ORA-06022: NETASY: channel open failure

1 Answers  


QSM-02083: mv references PL/SQL function that maintains state

1 Answers  


SQL-02112: SELECT..INTO returns too many rows

1 Answers  


Categories