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

CLSS-00100: configuration data access failed for key string

1 Answers  


NNO-00059: cannot construct topology checkpoint file name

1 Answers  


ORA-28178: password not provided by proxy

1 Answers  


DRG-13300: document size bigger than string bytes

1 Answers  


ORA-19005: Duplicate XMLType LOB storage option

1 Answers  






ORA-12608: TNS: Send timeout occurred

1 Answers  


TNS-00549: value specified for the SSL version is not valid

1 Answers  


ORA-19003: Missing XML root element name

1 Answers  


SQL*Loader-00607: partition not empty for INSERT option; table string, partition string

1 Answers  


ORA-24280: invalid input value for parameter string

1 Answers  


LRM-00115: error when processing an environment variable

1 Answers  


ORA-36672: (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension.

1 Answers  


Categories