ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

Cause : Auque exesisti nht euque eatlb ehwci hah son tebned orppde .lA luquesen ee dotb erdpoep difsr.t

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

rDpoa llq eueu sebolgnni gott ih suque eatlb esuni ght erdpoq_eueu)(c moamdn .eBs ru eots ot pht euquesea pporrpaietylb fero erdpoipgnt eh.mA tlreanetyl ,su eht eofcr epoitnoi nrdpoq_eueuatlb.e

update : 27-06-2017
ORA-24012

ORA-24012 - cannot drop QUEUE_TABLE, some queues in string have not been dropped
ORA-24012 - cannot drop QUEUE_TABLE, some queues in string have not been dropped

  • ora-00238 : operation would reuse a filename that is part of the database
  • ora-19107 : invalid XQueryX - unsupported construct - string
  • ora-12551 : TNS:missing keyword
  • ora-36684 : (XSDPART22) You cannot rename values of DIMENSION workspace object because it is the partition dimension of RANGE PARTITION TEMPLATE workspace object
  • ora-06127 : NETTCP: unable to change username
  • ora-16746 : resource guard encountered errors during database mount
  • ora-29803 : missing ANCILLARY keyword
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-36768 : (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.
  • ora-10361 : check buffer change vector count consistency
  • ora-10266 : Trace OSD stack usage
  • ora-37070 : You may not execute OLAP DML programs in a parallel query session.
  • ora-15176 : file 'string' already has an alias associated with it
  • ora-13527 : invalid baseline name
  • ora-02298 : cannot validate (string.string) - parent keys not found
  • ora-30044 : 'Retention' can only specified for undo tablespace
  • ora-02191 : correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
  • ora-13377 : invalid combination of elements with orientation
  • ora-02033 : a cluster index for this cluster already exists
  • ora-07716 : sksachk: invalid device specification for ARCHIVE
  • ora-09795 : szrbuild: malloc of role structure failed.
  • ora-31003 : Parent string already contains child entry string
  • ora-01032 : no such userid
  • ora-13334 : LRS segments not connected
  • ora-09885 : osnTXtt: cannot create TXIPC channel
  • ora-28024 : must revoke grants of external roles to this role/user
  • ora-30176 : invalid format code used in the format string
  • ora-22850 : duplicate LOB storage option specificed
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-07245 : sfccf: unable to lseek and write the last block.
  • 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.