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

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

1 Answers  


O2F-00305: Error opening the INTYPE file for reading

1 Answers  


EXP-00058: Password Verify Function for string profile does not exist

1 Answers   MR,


PLS-00414: no column 'string' in table

1 Answers  


NNL-00534: query <name> [<type>] : query for a desired name and RR type

1 Answers  






EXP-00022: must be SYS or SYSTEM to do incremental export

1 Answers  


ORA-08431: raw data missing zero as defined in picture

1 Answers  


ORA-09944: Password entry is corrupt.

1 Answers  


PCC-00090: Precision/scale specification must be given for DECIMAL datatype

1 Answers  


ORA-26059: Data is too large for column string

1 Answers  


TNS-00518: Incomplete read or write

1 Answers  


LSX-00330: missing range start character

1 Answers  


Categories