ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to
drop change tables



ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables..

Answer / guest

Cause: An attempt was made to use the SQL command DROP TABLE
for change tables, but DROP TABLE is not supported for
change tables.

Action: Use the DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE procedure
instead of the DROP TABLE command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00353: Not allowed

1 Answers  


DRG-51300: error getting dml Queue lock

1 Answers  


ORA-27142: could not create new process

1 Answers  


IMG-00802: empty or null attribute string

1 Answers  


ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.

1 Answers  


ORA-13856: Service name must be specified

1 Answers  


ORA-13011: value is out of range

1 Answers  


ORA-30151: File already exists

1 Answers  


NZE-29051: The given public key type is not supported.

1 Answers  


ORA-02750: osnfsmmap: cannot open shared memory file ?/dbs/ftt_<pid>.dbf

1 Answers  


ORA-31697: aborting operation at process order number string

1 Answers  


ORA-14135: a LOB column cannot serve as a partitioning column

1 Answers  


Categories