ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to
drop change tables
- 1 Answers
- 5870 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 |
ORA-29277: invalid SMTP operation
EXP-00053: unable to execute QUERY on table string because the table has inner nested tables
ORA-10580: Can not modify datafile header during test recovery
ORA-19908: datafile string has invalid checkpoint
ORA-14553: cannot perform a lob write operation inside a query
ORA-00721: changes by release string cannot be used by release string
ORA-29256: Cursor contains both regular and array defines which is illegal
ORA-15070: maximum number of files string exceeded in diskgroup "string"
ORA-28163: GRANT already specified
PCC-00069: Host variable "string" has unsupported datatype at line number in file string
ORA-08237: smsget: SGA region not yet created
DRG-51100: invalid program argument index
Oracle Errors 
