ORA-22806: not an object or REF

Cause : A nattepmtw a smdaet oe xrtatc na tatirbtuef rmo na tie mtahti sn etihre na bojcetn o raR E.F

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

Ues na bojcett yep ro ERFt yep tie madn ertyr hteo preaito.n

update : 27-06-2017
ORA-22806

ORA-22806 - not an object or REF
ORA-22806 - not an object or REF

  • ora-08112 : a composite partition may not be coalesced as a whole
  • ora-29901 : function underlying operator binding does not exist
  • ora-24328 : illegal attribute value
  • ora-10645 : Recursive Extension in SYSTEM tablespace during migration
  • ora-33413 : (EIFMAKEF01) You cannot export compressed composite workspace object because one of its bases has limited status or a PERMIT READ restriction.
  • ora-31022 : Element not found
  • ora-13827 : null or zero length attribute specified in SQL profile collection
  • ora-27074 : unable to determine limit for open files
  • ora-34357 : (MXDSS10) string is not an alias of analytic workspace string.
  • ora-27414 : Invalid BY value type
  • ora-24318 : call not allowed for scalar data types
  • ora-32774 : more than one file was specified for bigfile tablespace string
  • ora-28506 : parse error in data dictionary translation for string stored in string
  • ora-36986 : (XSRELGID05) Relation workspace object must be dimensioned by workspace object.
  • ora-14124 : duplicate REVERSE clause
  • ora-00309 : log belongs to wrong database
  • ora-27483 : "string.string" has an invalid END_DATE
  • ora-09758 : osnipn: could not check port in name server.
  • ora-31078 : error in SQL mapping information
  • ora-16005 : database requires recovery
  • ora-03238 : unable to extend LOB segment string.string subpartition string by string in tablespace string
  • ora-25305 : enqueue failed, expiration must be zero for queue string.string
  • ora-16558 : the database specified for switchover is not a standby database
  • ora-19706 : invalid SCN
  • ora-32130 : invalid offset/index refrenced in Bytes
  • ora-26737 : version string already has an export dump file
  • ora-12438 : repeated policy option: string
  • ora-01412 : zero length not allowed for this datatype
  • ora-29341 : The transportable set is not self-contained
  • ora-01607 : cannot add logfile to the specified instance
  • 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.