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 : 30-04-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-24354 : number fetched too large to fit in COBOL display type buffer.
  • ora-24127 : TABLESPACE parameter specified with an ACTION other than CREATE_ACTION
  • ora-16702 : generic resource guard warning
  • ora-12433 : create trigger failed, policy not applied
  • ora-18000 : invalid outline name
  • ora-30359 : Query rewrite is not supported on SYS materialized views
  • ora-06255 : NETNTT: cannot read pid of remote process
  • ora-00479 : RVWR process terminated with error string
  • ora-16108 : database is no longer a standby database
  • ora-19621 : archivelog range has already been specified
  • ora-09948 : Process information label retrieval failed.
  • ora-07228 : rtecho: unable to restore terminal to echo mode.
  • ora-16034 : FROM parameter is incompatible with MANAGED recovery
  • ora-13352 : the coordinates do not describe a circle
  • ora-01315 : Log file has been added or removed during select
  • ora-01637 : rollback segment 'string' is being used by another instance (#string)
  • ora-02492 : missing required file block increment size in NEXT clause
  • ora-14031 : partitioning column may not be of type LONG or LONG RAW
  • ora-16530 : invalid buffer or length
  • ora-29266 : end-of-body reached
  • ora-04046 : results of compilation are too large to support
  • ora-38703 : Type string in header is not a flashback database log file.
  • ora-29857 : domain indexes and/or secondary objects exist in the tablespace
  • ora-25957 : join index where clause cannot contain cycles
  • ora-30131 : number of keys being set exceeds allocation
  • ora-13855 : Tracing for service (module/action) string on instance string is already enabled
  • ora-12224 : TNS:no listener
  • ora-30178 : duplicate flag used in a format specification
  • ora-02245 : invalid ROLLBACK SEGMENT name
  • ora-02204 : ALTER, INDEX and EXECUTE not allowed for views
  • 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.