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-08-2017
ORA-22810

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

  • ora-01532 : cannot create database; instance being started elsewhere
  • ora-27192 : skgfcls: sbtclose2 returned error - failed to close file
  • ora-09910 : Unable to find ORACLE password file entry for user.
  • ora-37086 : %s is not a valueset
  • ora-09790 : sllfcf: unable to close file.
  • ora-29303 : user does not login as SYS
  • ora-19641 : backup datafile checkpoint is SCN string time string
  • ora-12665 : NLS string open failed
  • ora-01589 : must use RESETLOGS or NORESETLOGS option for database open
  • ora-19901 : database needs more recovery to create new incarnation
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-16050 : destination exceeded specified quota size
  • ora-07700 : sksarch: interrupt received
  • ora-06766 : TLI Driver: close failed during release
  • ora-12509 : TNS:listener failed to redirect client to service handler
  • ora-29740 : evicted by member string, group incarnation string
  • ora-32833 : failure string trying to release administration lock
  • ora-24236 : source text is empty
  • ora-12537 : TNS:connection closed
  • ora-31477 : could not detach LogMiner session during cleanup
  • ora-10900 : extent manager fault insertion event #string
  • ora-29843 : indextype should support atleast one operator
  • ora-01620 : no public threads are available for mounting
  • ora-02738 : osnpwrtbrkmsg: incorrect number of bytes written
  • ora-29911 : null scan context returned by ODCIIndexStart() routine
  • ora-07751 : slemcr: malloc failure
  • ora-12429 : label list range exceeded
  • ora-19694 : some changed blocks were not found in the change tracking file
  • ora-19043 : Multiply nested XMLROOT function disallowed
  • ora-16650 : command incompatible when Fast-Start Failover is enabled
  • 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.