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

PLS-00353: 'string' must name a user in the database

1 Answers  


ORA-32583: query passed to table function has wrong number of elements in select list

1 Answers  


ORA-09874: TASDEF_READ: read error, unable to read tasdef@.dbf file.

1 Answers  


ORA-31411: change set string is referenced by a change table

1 Answers  


ORA-26057: Conversion is not necessary for this direct path stream.

1 Answers  






LPX-00213: comment did not end in "-->"

1 Answers  


QSM-01086: dimension(s) not present or not used in ENFORCED integrity mode

1 Answers  


ORA-37041: (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.

1 Answers  


PLS-00425: in SQL, function argument and return types must be SQL type

1 Answers  


ORA-13855: Tracing for service (module/action) string on instance string is already enabled

1 Answers  


NZE-28807: Cannot update the data source.

1 Answers  


ORA-07495: spwat: lm_wait failed.

1 Answers  


Categories