ORA-31441: table is not a change table



ORA-31441: table is not a change table..

Answer / guest

Cause: User attempted to execute the DROP_CHANGE_TABLE
procedure on a table that is not a CHANGE table. This can
also occur when a CHANGE table object has been orphaned.
CHANGE tables can become orphaned after a
CREATE_CHANGE_TABLE failure or an incomplete DROP_CHANGE_TABLE.

Action: Check spelling. If error was due to an incorrect
name, then retry the procedure using the correct name. To
drop a table that is not a CHANGE table, or an orphaned
CHANGE table, use the DROP TABLE DDL command instead.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-51021: undefined error in fuzzy matcher

1 Answers  


ORA-06955: Number of database servers exceed limit

1 Answers  


ORA-25243: CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string

1 Answers  


ORA-13401: duplicate entry for string in USER_SDO_GEOR_SYSDATA view

1 Answers  


NNO-00081: domain "string" has no name servers

1 Answers  






ORA-17509: Attempt to do i/o beyond block1 offset

1 Answers  


QSM-02007: multiple instances of the same table or view

1 Answers  


LFI-01005: Unable to fill buffer.

1 Answers  


QSM-02140: agg(expr) requires correspondng SUM(expr*expr) function

1 Answers  


TNS-12589: TNS:connection not bequeathable

1 Answers  


ORA-01600: at most one "string" in clause "string" of string

1 Answers  


ORA-30557: function based index could not be properly maintained

1 Answers  


Categories