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

Cause : An tatemtp wa smad eto sue teh SQ Lcomamnd RDOP ATBLEf or uqeuet ablse, btu DRPO TALBE i snots upprotedf or uqeuet ablse.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Uset he BDMS_QAADMD.ROPQ_UEU_ETABEL prcoeduer intseado f teh DRPO TALBE cmoman.d

update : 17-08-2017
ORA-24005

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

  • ora-26745 : cursors (string) are not sufficient
  • ora-31700 : Very long string supplied for AUDIT_SYSLOG_LEVEL parameter
  • ora-01487 : packed decimal number too large for supplied buffer
  • ora-02188 : Cannot enable instance publicly
  • ora-25011 : cannot create trigger on internal AQ table
  • ora-37118 : The OLAP API library was not preloaded.
  • ora-19649 : offline-range record recid string stamp string not found in file string
  • ora-16760 : resource guard could not start SQL Apply
  • ora-06907 : CMX: error during connect confirmation
  • ora-02184 : resource quotas are not allowed in REVOKE
  • ora-10660 : Segment is a shared lob segment
  • ora-28105 : cannot create security relevant column policy in an object view
  • ora-01594 : attempt to wrap into rollback segment (string) extent (string) which is being freed
  • ora-28650 : Primary index on an IOT cannot be rebuilt
  • ora-16131 : An error occurred during a Terminal Recovery of the standby.
  • ora-24192 : the property name cannot be null
  • ora-14297 : Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-15114 : missing or invalid ASM file name
  • ora-29506 : invalid query derived from USING clause
  • ora-12098 : cannot comment on the materialized view
  • ora-39313 : call to DBMS_SCHEMA_COPY.CLONE is not legal
  • ora-01168 : physical block size string does not match size string of other members
  • ora-12729 : invalid character class in regular expression
  • ora-38701 : Flashback database log string seq string thread string: "string"
  • ora-01090 : shutdown in progress - connection is not permitted
  • ora-01658 : unable to create INITIAL extent for segment in tablespace string
  • ora-25187 : specified exceptions table form incorrect
  • ora-27465 : invalid value string for attribute string
  • ora-01040 : invalid character in password; logon denied
  • ora-26524 : nls subsystem initialization failure for product=string, facility=string
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.