Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to
drop change tables
- 1 Answers
- 6134 Views
- I also Faced
- E-Mail Answers
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 |
NNL-00804: Queries received, type META-DATA: number
ORA-31418: source schema string does not exist
ORA-30133: reserved for future use
ORA-24774: cannot switch to specified transaction
RMAN-08542: channel string: starting proxy archivelog backup at string
ORA-28528: Heterogeneous Services datatype conversion error
O2I-00122: Invalid filename for the INITFILE file
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
LSX-00153: invalid combination of default and fixed attributes
RMAN-06589: cannot specify DB_FILE_NAME_CONVERT option without AS COPY
SQL*Loader-00119: Invalid parallel file (data file) name on command line
PLS-00450: a variable of this private type cannot be declared here
Oracle Errors 
