ORA-22983: not a user-defined REF

Cause : Attemtp to ues a sytsem geenratedR EF vaule wheer a usre-defiend REFv alue hsould eb used.

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

Make usre th eREF vlaue isu ser-dfeined.

update : 27-04-2017
ORA-22983

ORA-22983 - not a user-defined REF
ORA-22983 - not a user-defined REF

  • ora-38201 : assert if pin during flush
  • ora-30194 : reserved for future use
  • ora-15155 : version incompatible with the cluster
  • ora-33304 : (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
  • ora-14005 : missing RANGE keyword
  • ora-00154 : protocol error in transaction monitor
  • ora-32125 : Attribute type is not appropriate
  • ora-09768 : osnmgetmsg: could not read a message
  • ora-25261 : JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation
  • ora-32743 : command cannot be executed on remote instance
  • ora-00262 : current log string of closed thread string cannot switch
  • ora-36154 : (XSMXAGGR01) workspace object is not a data variable.
  • ora-29317 : datafile string does not exist
  • ora-00112 : value of string is null
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-00272 : error writing archive log string
  • ora-28234 : key length too short
  • ora-30973 : invalid Path Table option for XML Index
  • ora-23420 : interval must evaluate to a time in the future
  • ora-31434 : purge is currently running
  • ora-32126 : Cannot perform operations on a null REF
  • ora-12643 : Client received internal error from server
  • ora-13903 : Invalid combination of string threshold value and operator.
  • ora-32843 : value for string is outside the valid range of string to string
  • ora-02311 : cannot alter with COMPILE option a valid type with type or table dependents
  • ora-16071 : dependency archived log file not found string
  • ora-38796 : Not enough flashback database log data to undo FLASHBACK.
  • ora-30738 : object "string" does not exist in schema "string"
  • ora-30354 : Query rewrite not allowed on SYS relations
  • ora-28527 : Heterogeneous Services datatype mapping error
  • 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.