ORA-22900: the SELECT list item of THE subquery is not a collection type

Cause : Th eTH Esuqbueyr msut ESLETC an esetd atbl eorV ARARY tiem.

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

chnaget hes ubuqer ytoS ELCET anetsedt abel o rVARRAYi te.m

update : 17-08-2017
ORA-22900

ORA-22900 - the SELECT list item of THE subquery is not a collection type
ORA-22900 - the SELECT list item of THE subquery is not a collection type

  • ora-24450 : Cannot pre-process OCI statement
  • ora-00263 : there are no logs that need archiving for thread string
  • ora-29390 : some resource plans are not part of any top-plan
  • ora-23613 : Script string already exists
  • ora-13065 : cannot delete a child layer with a parent layer
  • ora-19267 : XQ0047 - module string not found
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-19614 : archivelog thread string sequence string not found in backup set
  • ora-25445 : invalid column number: string for table alias: string
  • ora-19760 : error starting change tracking
  • ora-25455 : evaluation error for rule set: string.string, evaluation context: string.string
  • ora-00060 : deadlock detected while waiting for resource
  • ora-39762 : streams must be loaded in conversion order
  • ora-07703 : error in archive text: need '/' after device type
  • ora-12699 : Native service internal error
  • ora-29318 : datafile string is online
  • ora-30691 : failed to allocate system resources while registering a TCP/IP connection for data traffic detection
  • ora-15166 : cluster in rolling downgrade from version [string] to [string]
  • ora-29875 : failed in the execution of the ODCIINDEXINSERT routine
  • ora-13043 : failed to read metadata from the _SDOLAYER table
  • ora-09825 : Unable to disable allowmacaccess privilege.
  • ora-29661 : Unable to find the superclass of the defined in the EXTERNAL NAME
  • ora-06904 : CMX: no transport address available for remote application
  • ora-24807 : LOB form mismatch
  • ora-07570 : szrfc: $IDTOASC failure
  • ora-19708 : log destination exceeds maximum length of string characters
  • ora-15042 : ASM disk "string" is missing
  • ora-09925 : Unable to create audit trail file
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-09370 : Windows 3.1 Two-Task driver ORACLE task timed out
  • 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.