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-06-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-31509 : publication does not exist
  • ora-12317 : logon to database (link name string) denied
  • ora-08459 : invalid format parameter length
  • ora-01328 : only one build operation may occur at one time
  • ora-13801 : invalid value for SQLTUNE_CATEGORY parameter
  • ora-29291 : file remove operation failed
  • ora-30462 : unsupported operator: string
  • ora-12074 : invalid memory address
  • ora-02284 : duplicate INCREMENT BY specifications
  • ora-37999 : Serious OLAP error: string. Please contact Oracle Technical Support.
  • ora-31199 : Warning in processing file string
  • ora-12551 : TNS:missing keyword
  • ora-31643 : unable to close dump file "string"
  • ora-07577 : no such user in authorization file
  • ora-09827 : SCLGT: atomic latch return unknown error.
  • ora-30036 : unable to extend segment by string in undo tablespace 'string'
  • ora-00226 : operation disallowed while alternate control file open
  • ora-30381 : REWRITE_TABLE is not compatible with Oracle version
  • ora-03124 : two-task internal error
  • ora-26506 : null global context
  • ora-00444 : background process "string" failed while starting
  • ora-12840 : cannot access a remote table after parallel/insert direct load txn
  • ora-30755 : error during expansion of view hierarchy
  • ora-03127 : no new operations allowed until the active operation ends
  • ora-16136 : Managed Standby Recovery not active
  • ora-16716 : clearing parameter LOG_ARCHIVE_DEST failed
  • ora-30740 : cannot grant UNDER privilege on this object
  • ora-28673 : Merge operation not allowed on an index-organized table
  • ora-25501 : ALTER SYSTEM QUIESCE RESTRICTED command failed
  • ora-16701 : generic resource guard request failed
  • 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.