ORA-22979: cannot INSERT object view REF or user-defined REF

Cause : Attempt to insert an object view REF or user-defined REF in a REF column created to store system generated REF values"

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

Make sure the REF to be inserted is not from an object view or from a user-defined REF column

update : 27-06-2017

ORA-22979 - cannot INSERT object view REF or user-defined REF
ORA-22979 - cannot INSERT object view REF or user-defined REF

  • ora-31208 : DBMS_LDAP: PL/SQL - Invalid LDAP Message.
  • ora-32144 : Cannot perform operation on a null interval
  • ora-16712 : the resource handle is invalid
  • ora-27078 : unable to determine limit for open files
  • ora-15032 : not all alterations performed
  • ora-12059 : prebuilt table "string"."string" does not exist
  • ora-07239 : slemrd: invalid file handle, seals do not match.
  • ora-16507 : unrecognized request identifier
  • ora-30380 : REWRITE_TABLE does not exist
  • ora-30053 : invalid upper limit snapshot expression
  • ora-19772 : change tracking file name exceeds limit of string characters
  • ora-12159 : TNS:trace file not writeable
  • ora-34061 : (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.
  • ora-02764 : Invalid package mode
  • ora-15025 : could not open disk 'string'
  • ora-12354 : secondary object being dropped
  • ora-12531 : TNS:cannot allocate memory
  • ora-31664 : unable to construct unique job name when defaulted
  • ora-08322 : scnmin: open/convert of bias lock failed
  • ora-27502 : IPC error deleting OSD context
  • ora-07512 : sscggtl: $enq unexpected return for client termination lock
  • ora-30389 : the source statement is not compatible with the destination statement
  • ora-01945 : DEFAULT ROLE[S] already specified
  • ora-30451 : internal error
  • ora-33304 : (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
  • ora-07617 : $FORMAT_CLASS failed translating the binary label to a string
  • ora-16821 : logical standby database dictionary not yet loaded
  • ora-32767 : No server connection for this operation
  • ora-07252 : spcre: semget error, could not allocate semaphores.
  • ora-12334 : database (link name string) is still open
  • 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.