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 : 28-04-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-07339 : spcre: maximum number of semaphore sets exceeded.
  • ora-13181 : unable to determine length of column string_SDOINDEX.SDO_CODE
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-24314 : service handle not initialized
  • ora-00348 : single-process redo failure. Must abort instance
  • ora-40301 : invalid cost matrix specification
  • ora-28350 : cannot encrypt the specified column recorded in CDC synchronized change table
  • ora-02052 : remote transaction failure at string
  • ora-14104 : RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices
  • ora-32577 : username must be SYS or SYSTEM
  • ora-19500 : device block size string is invalid
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-38954 : Cross platform transport is not supported between source platform identifier string and target platform identifier string
  • ora-29807 : specified operator does not exist
  • ora-13464 : error loading GeoRaster data: string
  • ora-08106 : cannot create journal table string.string
  • ora-36912 : (XSAGDNGL48) In AGGMAP workspace object, MODEL workspace object cannot be simultaneous.
  • ora-16206 : database already configured as Logical Standby database
  • ora-27155 : could not execute file
  • ora-09838 : removeCallback: failure removing the callback port.
  • ora-14617 : cannot add/drop values to DEFAULT subpartition
  • ora-01293 : mounted database required for specified LogMiner options
  • ora-06257 : NETNTT: cannot send command line to shadow process
  • ora-25954 : missing primary key or unique constraint on dimension
  • ora-19953 : database should not be open
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-25007 : functions or methods not allowed in WHEN clause
  • ora-01911 : CONTENTS keyword expected
  • ora-24043 : destination string uses a reserved name, names with AQ$_ prefix are not valid
  • 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.