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-04-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-13360 : invalid subtype in a compound type
  • ora-29316 : datafile string been imported twice
  • ora-07256 : sptrap: cannot set up signal handler to catch exceptions.
  • ora-00609 : could not attach to incoming connection
  • ora-17508 : I/O request buffer ptr is not alligned
  • ora-24433 : This statement has already been prepared using OCIStmtPrepare2.
  • ora-09815 : File name buffer overflow
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-00204 : error in reading (block string, # blocks string) of control file
  • ora-22807 : cannot resolve to a scalar type or a collection type
  • ora-13620 : The task or object string is read-only and cannot be deleted or modified.
  • ora-36690 : (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
  • ora-12650 : No common encryption or data integrity algorithm
  • ora-25296 : Queue Table string has a buffered queue string
  • ora-24373 : invalid length specified for statement
  • ora-22606 : pickler image handle [string] is not well-formed
  • ora-19649 : offline-range record recid string stamp string not found in file string
  • ora-04077 : WHEN clause cannot be used with table level triggers
  • ora-07473 : snclrd: read error when trying to read sgadef.dbf file.
  • ora-24302 : host connection in use by another thread
  • ora-19252 : XQ0032 - too many declarations for base URI
  • ora-01909 : REUSE keyword expected
  • ora-23489 : duplicate entry "string"
  • ora-38764 : flashback not started; datafile string enabled threads are different
  • ora-30771 : Cannot add more than one referential constraint on REF column "string"
  • ora-30569 : data type of given column is not supported in a log group
  • ora-25454 : error during evaluation of rule set: string.string for iterator: string
  • ora-13706 : Invalid value "string" specified for parameter "string" in "string" analysis mode.
  • ora-16044 : destination string attribute cannot be specified at session level
  • ora-29908 : missing primary invocation for ancillary operator
  • 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.