ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop
queue tables



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

Post New Answer

More Oracle Errors Interview Questions

PLS-00143: duplicate external LANGUAGE specification in subprogram expression

1 Answers  


ORA-07507: scgcm: unexpected lock status condition

1 Answers  


RMAN-06065: The backup operand [string] conflicts with another specified operand.

1 Answers  


NNO-00610: detected possible alias loop involving name "string"

1 Answers  


ORA-23471: template not authorized for user

1 Answers  






PCC-02135: CMD-LINE: User asked for help

1 Answers  


ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]

1 Answers  


ORA-16083: LogMiner session has not been created

1 Answers  


ORA-30005: missing or invalid WAIT interval

1 Answers  


RMAN-06221: Removing automatic instance

1 Answers  


PCC-02429: Expecting an expression of some internal LOB type

1 Answers  


ORA-13852: Tracing for service(module/action) string is not enabled

1 Answers  


Categories