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 : 23-05-2017

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

  • ora-01216 : thread string is expected to be disabled after CREATE CONTROLFILE
  • ora-14319 : DEFAULT cannot be specified with other values
  • ora-07629 : smpall: $EXPREG failure
  • ora-22286 : insufficient privileges on file or directory to perform string operation
  • ora-13448 : GeoRaster metadata BRS error
  • ora-07261 : spdde: kill error, unable to send signal to process.
  • ora-00026 : missing or invalid session ID
  • ora-00020 : maximum number of processes (string) exceeded
  • ora-31695 : Inconsistent master table on restart. The following SQL statement returned string identical objects. string
  • ora-01296 : character set mismatch between dictionary string and logfiles
  • ora-00702 : bootstrap verison 'string' inconsistent with version 'string'
  • ora-01505 : error in adding log files
  • ora-28055 : the password will expire within string days
  • ora-12804 : parallel query server appears to have died
  • ora-00116 : SERVICE_NAMES name is too long
  • ora-24169 : rule condition has unrecognized variables
  • ora-24772 : Cannot mix tightly-coupled and loosely-coupled branches
  • ora-14307 : partition contains too many list values
  • ora-01540 : tablespace 'string' is not offline
  • ora-02783 : Both post and wait functions were not specified
  • ora-26575 : remote database does not support replication parallel propagation
  • ora-25531 : MTTR specified is too small: string
  • ora-16065 : remote archival disabled at standby destination
  • ora-30937 : No schema definition for 'string' (namespace 'string') in parent 'string'
  • ora-14099 : all rows in table do not qualify for specified partition
  • ora-32018 : parameter cannot be modified in memory on another instance
  • ora-16817 : unsynchronized Fast-Start Failover configuration
  • ora-06318 : IPA: Local maximum number of connections exceeded
  • ora-00131 : network protocol does not support registration 'string'
  • ora-26079 : file "string" is not part of table string.string
  • 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.