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-06-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-16567 : Data Guard broker internal parser error at "string"
  • ora-01881 : timezone region id number is invalid
  • ora-04098 : trigger 'string.string' is invalid and failed re-validation
  • ora-01928 : GRANT option not granted for all privileges
  • ora-12831 : Must COMMIT or ROLLBACK after executing INSERT with APPEND hint
  • ora-39026 : master table is inconsistent on validation string
  • ora-27547 : Unable to query IPC OSD attribute string
  • ora-16030 : session specific change requires a LOG_ARCHIVE_DEST_n destination
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-32833 : failure string trying to release administration lock
  • ora-36178 : (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.
  • ora-06307 : IPA: Cannot reset connection
  • ora-32805 : identifier for string too long, maximum length is string characters
  • ora-16233 : The table string.string is unsupported now
  • ora-28546 : connection initialization failed, probable Net8 admin error
  • ora-32309 : object mview type "string"."string" does not match the master table type
  • ora-06138 : NETTCP: error during connection handshake
  • ora-09314 : sltln: error translating logical name
  • ora-30757 : cannot access type information
  • ora-12098 : cannot comment on the materialized view
  • ora-04031 : unable to allocate string bytes of shared memory ("string","string","string","string")
  • ora-16766 : Redo Apply unexpectedly offline
  • ora-01720 : grant option does not exist for 'string.string'
  • ora-38418 : ADT associated with the attribute set string does not exist
  • ora-28054 : the password has expired. string Grace logins are left
  • ora-12035 : could not use materialized view log on "string"."string"
  • ora-37118 : The OLAP API library was not preloaded.
  • ora-22853 : invalid LOB storage option specification
  • ora-09207 : sfsrd: error reading from file
  • ora-06601 : LU6.2 Driver: Invalid database ID 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.