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

ORA-02236: invalid file name

1 Answers  


NNL-00556: set|show reset_stats_interval [<seconds>] [<server_list>] : set|show server statistic counter reset interval

1 Answers  


ORA-23536: the object "string"."string" is not cached at the middle tier as expected.

1 Answers  


ORA-14622: Value string already exists in subpartition string

1 Answers  


ORA-01763: update or delete involves outer joined table

1 Answers  






ORA-13140: invalid target type

1 Answers  


SQL*Loader-00710: Internal error: direct path stream buffer not loaded

1 Answers  


ORA-14407: partitioned table contains subpartitions in a different tablespace

1 Answers  


TNS-00084: * trace_off - ask process name to turn tracing off

1 Answers  


ORA-14401: inserted partition key is outside specified partition

1 Answers  


SQL*Loader-00950: Error shipping data structures across 2-task

1 Answers  


ORA-36740: A CHILDLOCK was detected in your valueset

1 Answers  


Categories