ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE

Cause : Th escehmas peicfide i nth eQUUEE_ANMEp armaetre o fCRAETEQ_UEEU i sno tth esaem a sth escehmas peicfide i nth eQUUEE_ATBL Epaarmeetr.

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

Us eth esaem shcem anaem fro btoh hte UQEU_ENAEM adn QEUUET_ABEL praamteer san drerty hte ocmmnad.

update : 22-08-2017

ORA-24037 - schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE
ORA-24037 - schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE

  • ora-02235 : this table logs changes to another table already
  • ora-24049 : invalid agent name string, names with AQ$_ prefix are not valid
  • ora-12551 : TNS:missing keyword
  • ora-38418 : ADT associated with the attribute set string does not exist
  • ora-06511 : PL/SQL: cursor already open
  • ora-27033 : failed to obtain file size limit
  • ora-09936 : Open of ORACLE password file for write failed.
  • ora-29864 : analyzing domain indexes marked LOADING/FAILED not supported
  • ora-19562 : file string is empty
  • ora-06802 : TLI Driver: could not open the /etc/netware/yellowpages file
  • ora-25258 : cannot register for notifications on an 8.0 style exception queue
  • ora-39955 : invalid PL/SQL warning message number
  • ora-02337 : not an object type column
  • ora-00078 : cannot dump variables by name
  • ora-01115 : IO error reading block from file string (block # string)
  • ora-25203 : invalid value string, DELAY should be non-negative
  • ora-07248 : sfwfb: write error, unable to write database block.
  • ora-02442 : Cannot drop nonexistent unique key
  • ora-14520 : Tablespace string block size [string] does not match existing object block size [string]
  • ora-23457 : invalid flavor ID string
  • ora-26102 : relative file # in file header is string rather than string for file string
  • ora-13291 : conversion error between the specified unit and standard unit
  • ora-31160 : max substitution group size string exceeded by "string" (string) for head element "string" (string)
  • ora-31519 : CDC subscription string already exists
  • ora-28510 : heterogeneous database link initialization failed
  • ora-40321 : invalid bin number, is zero or negative value
  • ora-00276 : CHANGE keyword specified but no change number given
  • ora-14457 : disallowed Nested Table column in a Temporary table
  • ora-23446 : duplicate template site
  • ora-40261 : input data for model build contains negative values
  • 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.