ORA-24004: invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY

Cause : nIavil doculnmn ma eaw spscefiei dnit ehS RO_TILTS.

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

hT eavil doculnmn masea erE QNT_MI Ena dRPOIIRYT.

update : 26-05-2017
ORA-24004

ORA-24004 - invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
ORA-24004 - invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY

  • ora-27009 : skgfwrt: cannot write to file opened for read
  • ora-25288 : AQ HTTP propagation encountered error, status-code number, string
  • ora-37037 : (XSMLTDCL03) You cannot RENAME objects in analytic workspace string because it is attached in MULTI mode.
  • ora-27142 : could not create new process
  • ora-15048 : ASM internal files cannot be deleted
  • ora-19830 : error from target database: string
  • ora-25299 : Invalid message delivery_mode
  • ora-14326 : Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
  • ora-37102 : (XSVPART02) Invalid partition name string.
  • ora-09794 : szrbuild: length of role name is greater than buffer.
  • ora-15046 : ASM file name 'string' is not in single-file creation form
  • ora-00031 : session marked for kill
  • ora-01317 : Not attached to a Logminer session
  • ora-24182 : attribute number specified does not exist
  • ora-16726 : the external condition supplied to resource guard is invalid
  • ora-12010 : cannot create materialized view log on table owned by SYS
  • ora-19372 : invalid update condition
  • ora-15044 : ASM disk 'string' is incorrectly named
  • ora-24054 : cannot propagate to an Oracle 8.0.3 release or lower release
  • ora-15050 : disk "string" contains string error(s)
  • ora-33918 : (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
  • ora-19609 : %s is from different backup set: stamp string count string
  • ora-13831 : SQL profile name specified is invalid
  • ora-02048 : attempt to begin distributed transaction without logging on
  • ora-13464 : error loading GeoRaster data: string
  • ora-16957 : SQL Analyze time limit interrupt
  • ora-31114 : XDB configuration has been deleted or is corrupted
  • ora-13368 : simple polygon type has more than one exterior ring
  • ora-31017 : Error generating unique OID for XML document
  • ora-16087 : graceful switchover requires standby or current control file
  • 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.