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 : 18-08-2017

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

  • ora-08117 : Index Organized Table operation released its block pin
  • ora-02361 : error while attempting to allocate number bytes of memory
  • ora-00117 : PROTOCOL, ADDRESS or DESCRIPTION must be specified
  • ora-01522 : file 'string' to be renamed does not exist
  • ora-23442 : object already exists for the refresh group template
  • ora-25276 : table specified is not a queue table
  • ora-22609 : error string during initialization of FDO
  • ora-25008 : no implicit conversion to LOB datatype in instead-of trigger
  • ora-25005 : cannot CREATE INSTEAD OF trigger on a read-only view
  • ora-06712 : TLI Driver: error on accept
  • ora-24088 : AQ Agent string does not exist
  • ora-29915 : cannot select FOR UPDATE from collection operand
  • ora-02289 : sequence does not exist
  • ora-27046 : file size is not a multiple of logical block size
  • ora-12666 : Dedicated server: outbound transport protocol different from inbound
  • ora-39156 : error parsing dump file name "string"
  • ora-12813 : value for PARALLEL or DEGREE must be greater than 0
  • ora-00059 : maximum number of DB_FILES exceeded
  • ora-27022 : skgfqsbi: could not allocate memory for media manager
  • ora-24505 : cannot change character set id on the handle
  • ora-19379 : invalid time_limit or repeat_interval
  • ora-13024 : polygon has less than three segments
  • ora-30111 : no closing quote for value 'string'
  • ora-12207 : TNS:unable to perform navigation
  • ora-30196 : reserved for future use
  • ora-23387 : replication parallel push dequeue error
  • ora-29958 : fatal error occurred in the execution of ODCIINDEXCREATE routine
  • ora-03233 : unable to extend table string.string subpartition string by string in tablespace string
  • ora-12558 : TNS:protocol adapter not loaded
  • ora-39761 : stream reset required before loading this stream again
  • 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.