ORA-19372: invalid update condition

Cause : The usre attemtped to acll loa_dsqlsetw ith ani nvalidu pdate ocnditio.n

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

Check hte updaet condiiton (e..g, NEW.OCL1_NAM E>= OLDC.OL2_NAEM) and ertry th eoperatoin.

update : 18-08-2017
ORA-19372

ORA-19372 - invalid update condition
ORA-19372 - invalid update condition

  • ora-24067 : exceeded maximum number of subscribers for queue string
  • ora-32630 : multiple assignment in automatic order MODEL
  • ora-12633 : No shared authentication services
  • ora-15121 : ASM file name 'string' contains an invalid diskgroup name
  • ora-16733 : error executing dbms_logstdby.unskip procedure
  • ora-07456 : cannot set RESOURCE_MANAGER_PLAN when database is closed
  • ora-36268 : (XSCGMDLAGG01) 'string' is not a valid dimension value.
  • ora-30730 : referential constraint not allowed on nested table column
  • ora-01605 : missing numbers in clause "string" of string
  • ora-16227 : DDL skipped due to missing object
  • ora-12996 : cannot drop system-generated virtual column
  • ora-31494 : could not activate a LogMiner session
  • ora-32006 : %s initialization parameter has been deprecated
  • ora-06304 : IPA: Message receive error
  • ora-31691 : The worker received message number string from the MCP, which is invalid.
  • ora-16639 : specified instance inactive or currently unavailable
  • ora-22810 : cannot modify object attributes with REF dereferencing
  • ora-13033 : Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
  • ora-00477 : SNP* process terminated with error
  • ora-38784 : Cannot create restore point 'string'.
  • ora-33076 : (XSAGDNGL37) In AGGMAP workspace object, the value 'number' is not a valid value of dimension workspace object.
  • ora-13296 : incorrect coordinate system specification
  • ora-19559 : error sending device command: string
  • ora-27477 : "string.string" already exists
  • ora-16537 : child count exceeded
  • ora-01509 : specified name 'string' does not match actual 'string'
  • ora-22285 : non-existent directory or file for string operation
  • ora-16225 : Missing LogMiner session name for Streams
  • ora-09939 : Restoration of signal handlers failed.
  • ora-14290 : PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • 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.