ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop
queue tables
Answer / guest
Cause: An attempt was made to use the SQL command DROP TABLE
for queue tables, but DROP TABLE is not supported for queue
tables.
Action: Use the DBMS_AQADM.DROP_QUEUE_TABLE procedure
instead of the DROP TABLE command.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 3 No |
ORA-38761: thread string redo log sequence number string could not be accessed
ORA-13625: %s is an invalid advisor object type.
NZE-28853: Initialization failure
NZE-28865: SSL connection closed
ORA-06569: Collection bound by bind_array contains no elements
ORA-29843: indextype should support atleast one operator
NNO-00257: warning: cannot get serial number from region store
ORA-24812: character set conversion to or from UCS2 failed
ORA-01560: LIKE pattern contains partial or illegal character
ORA-12951: Attempt to change default permanent tablespace to temporary
RMAN-06034: at least 1 channel must be allocated to execute this command
ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE