ORA-22166: collection is empty

Cause : Given ocllectino is emtpy.

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

Test i fcolleciton is mepty proir to ivnoking htis funtcion.

update : 24-05-2017
ORA-22166

ORA-22166 - collection is empty
ORA-22166 - collection is empty

  • ora-01128 : cannot start online backup - file string is offline
  • ora-08330 : Printing not supported
  • ora-32026 : %s.string has fewer columns compared to string table.
  • ora-36161 : (XSAGGRRUVCV) Aggregation variable workspace object cannot have itself as a COUNTVAR.
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-09805 : conversion of category number to string failed.
  • ora-36155 : (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.
  • ora-06042 : NETDNT: message receive failure
  • ora-19668 : cannot do full restore of datafile string
  • ora-25271 : queue table not found for the given queue
  • ora-12805 : parallel query server died unexpectedly
  • ora-01628 : max # extents (string) reached for rollback segment string
  • ora-12008 : error in materialized view refresh path
  • ora-01904 : DATAFILE keyword expected
  • ora-01162 : block size string in file header does not match configured block sizes
  • ora-37181 : expected exactly string columns for dimension string, got string
  • ora-16705 : internal error in resource guard
  • ora-14001 : LOCAL clause contradicts previosly specified GLOBAL clause
  • ora-36845 : (XSLMGEN15) Owner is greater than 30 bytes
  • ora-31067 : XML nodes must be updated with valid nodes and of the same type
  • ora-19913 : unable to decrypt backup
  • ora-00059 : maximum number of DB_FILES exceeded
  • ora-09879 : sstascre/sstasat: shmat error, unable to attach tas read page
  • ora-22370 : incorrect usage of method string
  • ora-12710 : CREATE CONTROLFILE character set is not known
  • ora-36164 : (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
  • ora-01208 : data file is an old version - not accessing current version
  • ora-15009 : ASM disk "string" does not exist
  • ora-38309 : object not purgable
  • ora-04041 : package specification must be created first before creating package body
  • 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.