ORA-22904: invalid reference to a nested table column

Cause : invlaid sue o fa nsetedt abl ecolmun

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

remvoe ivnali drefreenc eto hte nsetedt abl ecolmun

update : 21-08-2017
ORA-22904

ORA-22904 - invalid reference to a nested table column
ORA-22904 - invalid reference to a nested table column

  • ora-01558 : out of transaction ID's in rollback segment string
  • ora-10655 : Segment can be shrunk
  • ora-08443 : syntax error in BLANK WHEN ZERO clause in mask options
  • ora-31464 : target table for the change table no longer exists
  • ora-01776 : cannot modify more than one base table through a join view
  • ora-12476 : least upper bound resulted in an invalid OS label
  • ora-32005 : error while parsing size specification [string]
  • ora-25300 : Cannot drop buffer for queue with buffered subscribers
  • ora-31451 : invalid value string for capture_values, expecting: OLD, NEW, or BOTH
  • ora-09215 : sfqio: error detected in IOCompletionRoutine
  • ora-22606 : pickler image handle [string] is not well-formed
  • ora-01036 : illegal variable name/number
  • ora-14622 : Value string already exists in subpartition string
  • ora-13007 : an invalid HEX character was detected
  • ora-16115 : %s\% of LogMiner dictionary loading is done
  • ora-13340 : a point geometry has more than one coordinate
  • ora-22911 : duplicate storage specification for the nested table item
  • ora-01241 : an external cache has died
  • ora-19284 : Encoding specification in version declaration not supported
  • ora-02366 : The following index(es) on table string were processed:
  • ora-38305 : object not in RECYCLE BIN
  • ora-32805 : identifier for string too long, maximum length is string characters
  • ora-34001 : (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.
  • ora-00231 : snapshot control file has not been named
  • ora-25017 : cannot reference NEW ROWID for movable rows in before triggers
  • ora-24034 : application string is already a subscriber for queue string
  • ora-38862 : FLASHBACK DATABASE in progress
  • ora-30926 : unable to get a stable set of rows in the source tables
  • ora-22331 : cannot alter an incomplete type
  • ora-12549 : TNS:operating system resource quota exceeded
  • 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.