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

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

  • ora-38701 : Flashback database log string seq string thread string: "string"
  • ora-24347 : Warning of a NULL column in an aggregate function
  • ora-07586 : spdcr: $SEARCH failure
  • ora-19957 : database should have no datafiles in unknown state
  • ora-13002 : specified level is out of range
  • ora-10634 : Segment is already being shrunk
  • ora-38861 : flashback recovery stopped before reaching recovery target
  • ora-36652 : (XSDUNION11) workspace object is not a string type dimension.
  • ora-14302 : only one list of added-LOB-storage-clauses can be specified in a statement
  • ora-13529 : Error occurred when flushing AWR table group
  • ora-07505 : scggt: $enq parent lock unexpected return
  • ora-09368 : Windows 3.1 Two-Task driver unable to spawn ORACLE
  • ora-12915 : Cannot alter dictionary managed tablespace to read write
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-23366 : integer value string is less than 1
  • ora-08465 : input mask contains more than 32 characters
  • ora-34000 : (MODCOMP13) You cannot use both workspace object and workspace object as model dimensions, because they are both surrogates of dimension workspace object.
  • ora-36923 : (XSVPMVTOPART04) workspace object is not a LIST or RANGE PARTITION TEMPLATE.
  • ora-26532 : replication parallel push simulated site failure
  • ora-00082 : memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring
  • ora-12834 : Instance group name, 'string', too long, must be less than string characters
  • ora-19005 : Duplicate XMLType LOB storage option
  • ora-31072 : Too many child nodes in XMLType fragment for updateXML
  • ora-06106 : NETTCP: socket creation failure
  • ora-00271 : there are no logs that need archiving
  • ora-16122 : applying large dml transaction at SCN string
  • ora-02140 : invalid tablespace name
  • ora-28528 : Heterogeneous Services datatype conversion error
  • ora-13145 : failed to generate range list
  • ora-29253 : Invalid count argument passed to procedure dbms_sql.define_array
  • 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.