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 : 17-08-2017
ORA-24002

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

  • ora-19003 : Missing XML root element name
  • ora-36846 : (XSLMGEN16) AW name is greater than 30 bytes
  • ora-06403 : Unable to allocate memory.
  • ora-00406 : COMPATIBLE parameter needs to be string or greater
  • ora-00443 : background process "string" did not start
  • ora-27205 : skgfpcn: sbtpccancel returned error
  • ora-02064 : distributed operation not supported
  • ora-29516 : Aurora assertion failure: string
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-28051 : the account is locked
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-36872 : (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.
  • ora-36820 : (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.
  • ora-00076 : dump string not found
  • ora-35810 : (XSINPUTERR) The command has requested more input than was supplied in the command string.
  • ora-25207 : enqueue failed, queue string.string is disabled from enqueueing
  • ora-39111 : Dependent object type string skipped, base object type string already exists
  • ora-39020 : invalid mode type string
  • ora-29256 : Cursor contains both regular and array defines which is illegal
  • ora-00237 : snapshot operation disallowed: control file newly created
  • ora-01213 : MAXINSTANCES may not exceed string
  • ora-10655 : Segment can be shrunk
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-07452 : specified resource manager plan does not exist in the data dictionary
  • ora-24802 : user defined lob read callback error
  • ora-30117 : syntax error at 'string' at the start of input
  • ora-03236 : max # extents (string) reached in index string.string subpartition string
  • ora-30487 : ORDER BY not allowed here
  • ora-19332 : Invalid column in the CREATE_DBURI operator
  • ora-06777 : TLI Driver: error reading parms
  • 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.