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 : 30-04-2017
ORA-22904

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

  • ora-16016 : archived log for thread string sequence# string unavailable
  • ora-39317 : call to DBMS_SCHEMA_COPY.VALIDATION_CHECK is not legal
  • ora-31493 : could not prepare session for LogMiner session
  • ora-10943 : trace name context forever
  • ora-29960 : line string, string
  • ora-30574 : Cannot create rollback segment in tablespace with AUTO segment space management
  • ora-12067 : empty refresh groups are not allowed
  • ora-26762 : Cannot autogenerate name for parameter string because of the following reason: string
  • ora-01107 : database must be mounted for media recovery
  • ora-29961 : too many warnings occurred in the execution of ODCIIndex DDL routine
  • ora-08106 : cannot create journal table string.string
  • ora-02227 : invalid cluster name
  • ora-03124 : two-task internal error
  • ora-33625 : (FRASSIGN02) You cannot use the APPEND keyword with concat dimension workspace object.
  • ora-31025 : Invalid document element
  • ora-37128 : (XSCCOMP03) It is not possible to PARTITION over a base of a COMPRESSED COMPOSITE.
  • ora-16801 : redo transport-related property is inconsistent with database setting
  • ora-27203 : skgfpqb: sbtpcquerybackup returned error
  • ora-07573 : slkhst: could not perform host operation
  • ora-38769 : FLASHBACK DATABASE failed after modifying data.
  • ora-29971 : Specified table name not found or does not have any registrations
  • ora-02170 : FREELIST GROUPS storage option not allowed
  • ora-13443 : GeoRaster metadata SRS error
  • ora-01911 : CONTENTS keyword expected
  • ora-29825 : invalid name for indextype
  • ora-28221 : REPLACE not specified
  • ora-37043 : (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.
  • ora-12539 : TNS:buffer over- or under-flow
  • ora-24804 : Lob read/write functions called while another OCI LOB read/write streaming is in progress
  • ora-23412 : master table's primary key columns have changed
  • 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.