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

ORA-24023: Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]

1 Answers  


ORA-13706: Invalid value "string" specified for parameter "string" in "string" analysis mode.

1 Answers  


LPX-00658: Invalid XSLT object type.

1 Answers  


ORA-28043: invalid bind credentials for DB-OID connection

1 Answers  


DRG-12511: use ctx_ddl.create_stoplist to create stoplists

1 Answers  






DRG-51403: New index name not provided by kernel

1 Answers  


ORA-03244: No free space found to place the control information

1 Answers  


TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.

1 Answers  


RMAN-02001: unrecognized punctuation symbol "string"

1 Answers  


ORA-02055: distributed update operation failed; rollback required

1 Answers  


NNL-00523: Renames an existing name

1 Answers  


ORA-06044: NETDNT: connect failed, byte count quota exceeded

1 Answers  


Categories