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

RMAN-20311: ambiguous proxy copy handle

1 Answers  


ORA-19719: length for operation name longer than string

1 Answers  


ORA-29382: validation of pending area failed

1 Answers  


TNS-00269: OFF

1 Answers  


ORA-14402: updating partition key column would cause a partition change

2 Answers  






ORA-12981: cannot drop column from an object type table

1 Answers  


NNL-00574: dump_tnsnames [<file>] : dump ONames addresses into tnsnames file

1 Answers  


ORA-07281: slsget: times error, unable to get cpu time.

1 Answers  


DRG-52112: improper Chinese string string of length number

1 Answers  


ORA-06559: wrong datatype requested, string, actual datatype is string

1 Answers  


PLS-00133: Pragma string expects 1st argument to be an identifier or string-literal

1 Answers  


QSM-01526: query rewrite is disabled for equivalence, string

1 Answers  


Categories