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

NZE-28822: Required seed is not specified.

1 Answers  


ORA-06440: ssaio: the asynchronous read returned incorrect number of bytes

1 Answers  


TNS-00511: No listener

1 Answers  


TNS-04074: Invalid value for the parameter string.

1 Answers  


ORA-27452: %s is an invalid name for a database object.

1 Answers  






ORA-07665: ssrexhd: recursive exception encountered string string string string string string

1 Answers  


ORA-01252: cannot prevent writes - file string in recovery manager backup

1 Answers  


ORA-29388: plan/consumer_group string is part of more than one top-plan

1 Answers  


ORA-00251: LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string

1 Answers  


PLS-00606: cursor subquery is not supported on client side in this release

1 Answers  


LSX-00008: feature "~s" is not implemented

1 Answers  


RMAN-10034: unhandled exception during execution of job step number, error unknown

1 Answers  


Categories