ORA-22880: invalid REF

Cause : An invlaid REFw as accsesed.

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

Modifyt he REFa nd retyr the oepration.

update : 19-08-2017

ORA-22880 - invalid REF
ORA-22880 - invalid REF

  • ora-28042 : Server authentication failed
  • ora-02271 : table does not have such constraint
  • ora-24357 : internal error while converting from to OCIDate.
  • ora-23622 : Operation string.string.string is in progress.
  • ora-24089 : AQ Agent string already exists
  • ora-30734 : cannot specify scope constraint on ref column with rowid
  • ora-29394 : session id string and serial# string do not exist
  • ora-27194 : skgfdvcmd: sbtcommand returned error
  • ora-31418 : source schema string does not exist
  • ora-01494 : invalid SIZE specified
  • ora-28154 : Proxy user may not act as client 'string'
  • ora-28239 : no key provided
  • ora-31401 : change source string is not an existing change source
  • ora-22893 : constraint can be specified only for REF columns
  • ora-01231 : cannot make read write - file string is offline
  • ora-25006 : cannot specify this column in UPDATE OF clause
  • ora-21709 : cannot refresh an object that has been modified
  • ora-35756 : (VCTODT02) 'number' is not a valid date because number is out of range for a year.
  • ora-38462 : invalid attribute list
  • ora-23443 : missing template parameter
  • ora-01189 : file is from a different RESETLOGS than previous files
  • ora-10852 : Enable tracing for Enqueue Dequeue Operations
  • ora-01552 : cannot use system rollback segment for non-system tablespace 'string'
  • ora-16549 : invalid string
  • ora-30454 : summary contains STDDEV without corresponding SUM & COUNT
  • ora-27146 : post/wait initialization failed
  • ora-36641 : (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
  • ora-09241 : smsalo: error allocating SGA memory
  • ora-28110 : policy function or package string.string has error
  • ora-37011 : (XSACQUIRE_LOCKED) Object workspace object is locked by another user.
  • 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.