ORA-22810: cannot modify object attributes with REF dereferencing

Cause : An attempt was made to modify the attributes an object by dereferencing a REF column in an UPDATE statement.

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

Update the table containing the object that the REF points to, or change the REF column to an object type column.

update : 21-07-2017
ORA-22810

ORA-22810 - cannot modify object attributes with REF dereferencing
ORA-22810 - cannot modify object attributes with REF dereferencing

  • ora-16593 : XML conversion failed
  • ora-07750 : slemcr: fopen failure
  • ora-06763 : TLI Driver: error sending disconnect
  • ora-09215 : sfqio: error detected in IOCompletionRoutine
  • ora-21501 : program could not allocate memory
  • ora-13447 : GeoRaster metadata BRS error
  • ora-16733 : error executing dbms_logstdby.unskip procedure
  • ora-03008 : parameter COMPATIBLE >= string needed for string
  • ora-04033 : Insufficient memory to grow pool
  • ora-24417 : Session pool size has exceeded the maximum limit
  • ora-40217 : priors table mismatched with training data
  • ora-24231 : database access descriptor (DAD) string not found
  • ora-26095 : unprocessed stream data exists
  • ora-12402 : invalid format string: string
  • ora-02726 : osnpop: access error on oracle executable
  • ora-19668 : cannot do full restore of datafile string
  • ora-01276 : Cannot add file string. File has an Oracle Managed Files file name.
  • ora-40214 : duplicate setting: string
  • ora-09749 : pws_look_up: port lookup failure
  • ora-01274 : cannot add datafile 'string' - file could not be created
  • ora-40204 : model string already exists
  • ora-29519 : name string resolved via a synonym in schema string to a class with a different name
  • ora-00385 : cannot enable Very Large Memory with new buffer cache parameters
  • ora-01104 : number of control files (string) does not equal string
  • ora-25436 : invalid table alias: string
  • ora-30951 : Element or attribute at Xpath string exceeds maximum length
  • ora-02483 : Syntax error in process specification (string)
  • ora-22303 : type "string"."string" not found
  • ora-07700 : sksarch: interrupt received
  • ora-14048 : a partition maintenance operation may not be combined with other operations
  • 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.