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

RMAN-08093: specifying current controlfile for proxy backup

1 Answers  


QSM-02152: subquery or named view in FROM list even after view merging

1 Answers  


EXP-00089: invalid FILE_FORMAT specification

1 Answers  


ORA-02765: Invalid maximum number of servers

1 Answers  


ORA-10574: Test recovery did not corrupt any data block

1 Answers  


ORA-07605: szprv: $ASCTOID failure

1 Answers  


TNS-01163: Failed to spawn process: string

1 Answers  


ORA-09888: osnTXtt: txipc channel creation failed

1 Answers  


ORA-31012: Given XPATH expression not supported

1 Answers  


ORA-26699: STREAMS message consumer string already exists

1 Answers  


TNS-00266: Navigator: Unknown Request

1 Answers  


ORA-22826: cannot construct an instance of a non instantiable type

1 Answers  


Categories