ORA-38104: Columns referenced in the ON Clause cannot be updated: string

Cause : LHS o fUPDAT ESET cnotainst he coulmns rfeerencde in teh ON Caluse

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


update : 26-05-2017

ORA-38104 - Columns referenced in the ON Clause cannot be updated: string
ORA-38104 - Columns referenced in the ON Clause cannot be updated: string

  • ora-33060 : (XSAGDNGL29) In AGGMAP workspace object, the value for the ERRORLOG MAX option must be greater than 0.
  • ora-30045 : No undo tablespace name specified
  • ora-29851 : cannot build a domain index on more than one column
  • ora-29955 : error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine
  • ora-31081 : name not specified for global declaration
  • ora-12730 : invalid equivalence class in regular expression
  • ora-31017 : Error generating unique OID for XML document
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-30946 : XML Schema Evolution warning: temporary tables not cleaned up
  • ora-37155 : OLAP API bootstrap error: (case string)
  • ora-06926 : CMX: T_ERROR during read data
  • ora-12201 : TNS:encountered too small a connection buffer
  • ora-01106 : database must be closed before dismounting
  • ora-07840 : sllfop: LIB$GET_VM failure
  • ora-13865 : Module name must be specified
  • ora-01545 : rollback segment 'string' specified not available
  • ora-27454 : argument name and position cannot be NULL
  • ora-31516 : CDC change set string already exists
  • ora-01107 : database must be mounted for media recovery
  • ora-40284 : model does not exist
  • ora-31627 : API call succeeded but more information is available
  • ora-15121 : ASM file name 'string' contains an invalid diskgroup name
  • ora-30563 : outer join operator (+) not allowed in select-list
  • ora-25016 : cannot specify column list for insert into nested table view column
  • ora-38954 : Cross platform transport is not supported between source platform identifier string and target platform identifier string
  • ora-29507 : query derived from USING clause found zero or many rows
  • ora-23303 : application raised generic exception during deferred RPC
  • ora-14404 : partitioned table contains partitions in a different tablespace
  • ora-29275 : partial multibyte character
  • ora-32051 : mapping service not available
  • 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.