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 : 25-04-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-38201 : assert if pin during flush
  • ora-32772 : BIGFILE is invalid option for this type of tablespace
  • ora-19733 : COMPATIBLE parameter needs to be string or greater
  • ora-00452 : foreground process unexpectedly terminated with error string
  • ora-32510 : cannot create watchpoint on unreadable memory
  • ora-39169 : Local version of string cannot work with remote version of string.
  • ora-30964 : The XML Index was not usable.
  • ora-27121 : unable to determine size of shared memory segment
  • ora-12350 : database link being dropped is still mounted
  • ora-02160 : index-organized table can not contain columns of type LONG
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-04007 : MINVALUE cannot be made to exceed the current value
  • ora-31190 : Resource string is not a version-controlled resource
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-08343 : srclose: failed to close a redo server connection
  • ora-12496 : cannot change existing level, category, or release numbers
  • ora-26031 : index maintenance error, the load cannot continue
  • ora-39956 : duplicate setting for PL/SQL compiler parameter string
  • ora-12835 : No instances are active in the GLOBAL_VIEW_ADMIN_GROUP
  • ora-19655 : cannot switch to incarnation with different resetlogs data
  • ora-00364 : cannot write header to new log member
  • ora-30454 : summary contains STDDEV without corresponding SUM & COUNT
  • ora-19257 : XQ0037 - function or variable string in module already defined
  • ora-38710 : Flashback log version string is incompatible with ORACLE version string.
  • ora-09810 : Unable to get process ID from connection
  • ora-01336 : specified dictionary file cannot be opened
  • ora-02769 : Setting of handler for SIGTERM failed
  • ora-17504 : ksfddel:Failed to delete file string
  • ora-31450 : invalid value for change_table_name
  • 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.