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 : 29-04-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-08450 : invalid specification of CR in picture mask
  • ora-26741 : cannot assemble lobs
  • ora-09767 : osnmfs: bad return code from msg_send.
  • ora-37178 : column string has no values
  • ora-24408 : could not generate unique server group name
  • ora-03206 : maximum file size of (string) blocks in AUTOEXTEND clause is out of range
  • ora-19285 : FODC0002 - error retrieving resource
  • ora-12323 : unable to open database (link name string)
  • ora-16168 : LGWR network server could not switch to blocking mode
  • ora-27032 : failed to obtain file size limit
  • ora-22305 : attribute/method/parameter "string" not found
  • ora-15152 : cluster in rolling upgrade
  • ora-10573 : Test recovery tested redo from change string to string
  • ora-19676 : one or more files failed during proxy backup or restore
  • ora-28334 : column is already encrypted
  • ora-13193 : failed to allocate space for geometry
  • ora-27072 : File I/O error
  • ora-36834 : (XSLMGEN04) Column tag is greater than 30 bytes
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-17504 : ksfddel:Failed to delete file string
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-29879 : cannot create multiple domain indexes on a column list using same indextype
  • ora-38730 : Invalid SCN/TIMESTAMP expression.
  • ora-19030 : Method invalid for non-schema based XML Documents.
  • ora-14046 : a partition may be split into exactly two new partitions
  • ora-24348 : Update or Delete without Where
  • ora-06902 : CMX: cannot attach to cmx subsystem
  • ora-02732 : osnrnf: cannot find a matching database alias
  • ora-09313 : slsprom: error prompting user
  • ora-01636 : rollback segment 'string' is already online
  • 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.