ORA-22808: REF dereferencing not allowed

Cause : nAa ttmetpw sam da eota ccse snao jbce tyteps'a ttirubet sybd refereneicgna R FEi et.m

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

aMekt ehi et mnao jbce tytepi snetdao f aER Fota nboejtct py.e

update : 29-04-2017
ORA-22808

ORA-22808 - REF dereferencing not allowed
ORA-22808 - REF dereferencing not allowed

  • ora-12078 : fast refresh of refresh group ID string failed
  • ora-06978 : X.25 Driver: Too many callback tries
  • ora-06137 : NETTCP: error during connection handshake
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-07640 : smsget: SGA not yet valid. Initialization in progress
  • ora-04087 : cannot change the value of ROWID reference variable
  • ora-06510 : PL/SQL: unhandled user-defined exception
  • ora-01483 : invalid length for DATE or NUMBER bind variable
  • ora-23331 : column group string does not exist
  • ora-08320 : scnget: Call to scnget before scnset or scnfnd.
  • ora-29347 : Tablespace name validation failed - failed to match tablespace 'string'
  • ora-26500 : error on caching "string"."string"
  • ora-01755 : Must specify an extent number or block number
  • ora-12457 : security label exceeded maximum allowable length
  • ora-02251 : subquery not allowed here
  • ora-12317 : logon to database (link name string) denied
  • ora-00306 : limit of string instances in this database
  • ora-13777 : invalid list of attribute names
  • ora-40219 : apply result table string is incompatible with current operation
  • ora-27032 : failed to obtain file size limit
  • ora-38783 : Instance recovery required.
  • ora-37151 : MDX parser initialization error
  • ora-16238 : attempt to use version 9 log
  • ora-12088 : cannot online redefine table "string"."string" with unsupported datatype
  • ora-24432 : The statement that was returned is not tagged.
  • ora-38855 : cannot mark instance string (redo thread string) as enabled
  • ora-01751 : Invalid dump undo option
  • ora-08265 : create_ora_addr: cannot open nameserver
  • ora-37008 : (AWLISTALL06) number writers
  • ora-34719 : (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion
  • 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.