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-27507: IPC error disconnecting from a port
NNO-00333: warning: ROS admin_region types obsolete; using SQL
RMAN-08588: converted datafile=string
ORA-15024: discovered duplicately numbered ASM disk string
NID-00332: The following datafiles are in unknown state:
ORA-02275: such a referential constraint already exists in the table
ORA-02157: no options specified for ALTER USER
ORA-39501: failed to notify CRS of a Startup/Shutdown event [number] (ignored)
QSM-02117: missing GROUPING_ID or GROUPING functions on GROUP BY column(s)
ORA-02044: transaction manager login denied: transaction in progress
ORA-14032: partition bound of partition number string is too high
ORA-29399: user string does not have privilege to switch to consumer group string