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 |
PLS-00353: 'string' must name a user in the database
ORA-32583: query passed to table function has wrong number of elements in select list
ORA-09874: TASDEF_READ: read error, unable to read tasdef@.dbf file.
ORA-31411: change set string is referenced by a change table
ORA-26057: Conversion is not necessary for this direct path stream.
LPX-00213: comment did not end in "-->"
QSM-01086: dimension(s) not present or not used in ENFORCED integrity mode
ORA-37041: (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.
PLS-00425: in SQL, function argument and return types must be SQL type
ORA-13855: Tracing for service (module/action) string on instance string is already enabled
NZE-28807: Cannot update the data source.
ORA-07495: spwat: lm_wait failed.