ORA-24002: QUEUE_TABLE string does not exist

Cause : Queue_table not exist.

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

Query on the user view USER_QUEUE_TABLES to find out existing queue tables.

update : 28-06-2017

ORA-24002 - QUEUE_TABLE string does not exist
ORA-24002 - QUEUE_TABLE string does not exist

  • ora-30161 : A system error occurred during the OCIFile function call
  • ora-01494 : invalid SIZE specified
  • ora-35180 : (SNSYN103) The format of the OUTFILE command is: OUTFILE [APPEND] {EOF | TRACEFILE | filename [NOCACHE] [NLS_CHARSET name]}
  • ora-13182 : failed to read element string.string.string
  • ora-32575 : Explicit column default is not supported for modifying views
  • ora-30440 : can't fast refresh;refresh complete or set event 30441 for partial refresh
  • ora-30153 : An invalid File Object is passed to the OCIFile function
  • ora-38710 : Flashback log version string is incompatible with ORACLE version string.
  • ora-33278 : (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.
  • ora-15073 : diskgroup string is mounted by another ASM instance
  • ora-14104 : RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices
  • ora-30945 : Could not create mapping table 'string'
  • ora-32830 : result code string returned by Messaging Gateway agent
  • ora-16763 : redo transport service for a standby database is online
  • ora-01171 : datafile string going offline due to error advancing checkpoint
  • ora-02271 : table does not have such constraint
  • ora-13825 : missing SQL statement text for create SQL profile
  • ora-25335 : AQ array operations not allowed for buffered messages
  • ora-16700 : the standby database has diverged from the primary database
  • ora-02163 : invalid value for FREELIST GROUPS
  • ora-27156 : request for process information failed
  • ora-06722 : TLI Driver: connection setup failure
  • ora-27480 : window "string" is currently open
  • ora-12851 : PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string
  • ora-28582 : a direct connection to this agent is not allowed
  • ora-19566 : exceeded limit of string corrupt blocks for file string
  • ora-00308 : cannot open archived log 'string'
  • ora-02445 : Exceptions table not found
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-25270 : sender info does not match with the actual sender of the message
  • 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.