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 |
ORA-06709: TLI Driver: message send failure
ORA-19673: error during proxy copy of file string
ORA-31664: unable to construct unique job name when defaulted
ORA-18008: cannot find OUTLN schema
ORA-13826: empty SQL profile not allowed for create or update SQL profile
ORA-38734: Flashback log is inconsistent; belongs to another database.
ORA-09822: Translation of audit file name failed.
ORA-31025: Invalid document element
DRG-52100: %(1)s returned internal error code string
LSX-00282: duplicate notation name "~S"
PCC-00096: Array FETCH not allowed for mode=ANSI14
QSM-01028: materialized view, string, is currently being refreshed