ORA-22906: cannot perform DML on expression or on nested table view column

Cause : Attepmtde ot eprofr maD M Lo na nepxrsesoino ro na ensetdt albev iwe oclmunw hreea ensetdt albec oulm no fab aes atbel si xepcetde.

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

Olnyn etse dtbal eclounm fo absaet albei sa lolwde ni hteD M.L

update : 17-08-2017

ORA-22906 - cannot perform DML on expression or on nested table view column
ORA-22906 - cannot perform DML on expression or on nested table view column

  • ora-36767 : (XSAGGCNTMOVE05) workspace object cannot be used as an AGGCOUNT while there are permissions applied to it.
  • ora-02306 : cannot create a type that already has valid dependent(s)
  • ora-38311 : cannot purge objects owned by other users
  • ora-12317 : logon to database (link name string) denied
  • ora-19284 : Encoding specification in version declaration not supported
  • ora-32602 : FREEPOOLS and FREELIST GROUPS cannot be used together
  • ora-07757 : slemcc: invalid handle
  • ora-00286 : no members available, or no member contains valid data
  • ora-00475 : TRWR process terminated with error
  • ora-08401 : invalid compiler name: string
  • ora-16763 : redo transport service for a standby database is online
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-07803 : slpdtb: invalid packed decimal nibble
  • ora-38908 : internal error occurred during DML Error Logging
  • ora-31220 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet location.
  • ora-23620 : bind value size too large for PL/SQL CALL operation
  • ora-13293 : cannot specify unit for geometry without a georeferenced SRID
  • ora-24237 : object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-13644 : The user "string" is invalid.
  • ora-00314 : log string of thread string, expected sequence# string doesn't match string
  • ora-22826 : cannot construct an instance of a non instantiable type
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-15021 : parameter "string" is not valid in string instance
  • ora-33336 : (DSSEXIST04A) Analytic workspace string is not attached.
  • ora-39067 : Unable to close the log file.
  • ora-28672 : UPDATE BLOCK REFERENCES may not be used on a global index
  • ora-23531 : site owner already exists in the template.
  • ora-13196 : failed to compute supercell for element string.string.string
  • ora-14022 : creation of LOCAL partitioned cluster indices is not supported
  • ora-36997 : (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.
  • 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.