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 : 23-04-2017
ORA-22810

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

  • ora-02462 : Duplicate INDEX option specified
  • ora-00164 : distributed autonomous transaction disallowed within migratable distributed transaction
  • ora-03132 : two-task default value overflow
  • ora-16594 : %s process discovered that DMON process does not exist
  • ora-13119 : invalid edge_id [string]
  • ora-31428 : no publication contains all the specified columns
  • ora-31226 : DBMS_LDAP: MOD_ARRAY size limit exceeded
  • ora-07237 : slemcl: invalid file handle, seals do not match.
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • ora-12658 : ANO service required but TNS version is incompatible
  • ora-01327 : failed to exclusively lock system dictionary as required by build
  • ora-19025 : EXTRACTVALUE returns value of only one node
  • ora-39314 : call to DBMS_SCHEMA_COPY.SYNC_CODE is not legal
  • ora-38788 : More standby database recovery is needed
  • ora-38444 : statistics do not exist for the expression set
  • ora-15062 : ASM disk is globally closed
  • ora-31418 : source schema string does not exist
  • ora-16136 : Managed Standby Recovery not active
  • ora-25468 : column name not specified for alias: string
  • ora-30689 : improper value for ORA_DEBUG_JDWP
  • ora-01285 : error reading file string
  • ora-06307 : IPA: Cannot reset connection
  • ora-25241 : cannot change correlation ID from string to string without FIRST_MESSAGE option
  • ora-01559 : MAXEXTENTS for rollback segment must be greater than 1
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-10658 : Lob column to be shrunk is marked unused
  • ora-40223 : data mining model import failed, job name=string, error=string
  • ora-29928 : duplicate default selectivity specified
  • ora-02796 : Done request is not in correct state
  • ora-28349 : cannot encrypt the specified column recorded in the materialized view log
  • 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.