ORA-22890: cannot specify name for REF column constraint

Cause : A nattepmtw a smdaet os pceiyf acnosrtanitn aem ofra ocntsrian to naR E Fclounm.

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

Rmeoev htec osntaritn anm eadn ertyr hteo preaito.n

update : 26-06-2017
ORA-22890

ORA-22890 - cannot specify name for REF column constraint
ORA-22890 - cannot specify name for REF column constraint

  • ora-35024 : (QFCHECK04) The analytic workspace and EIF file definitions of workspace object have mismatched time dimension attributes.
  • ora-02093 : TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)
  • ora-13154 : invalid precision specified
  • ora-19681 : block media recovery on control file not possible
  • ora-01764 : new update value of join is not guaranteed to be unique
  • ora-31102 : Already locked in exclusive mode. Cannot add lock.
  • ora-29400 : data cartridge error string
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-02082 : a loopback database link must have a connection qualifier
  • ora-19017 : Attributes can only be simple scalars
  • ora-07242 : slembfn: translation error, unable to translate error file name.
  • ora-31427 : publication string already subscribed
  • ora-31662 : metadata transform name can not be defaulted
  • ora-31672 : Worker process string died unexpectedly.
  • ora-29534 : referenced object string.string could not be resolved
  • ora-01661 : tablespace 'string' is already temporary
  • ora-13788 : invalid recommendation type
  • ora-24199 : message store is overflow
  • ora-30483 : window functions are not allowed here
  • ora-00397 : instance recovery process terminated with error
  • ora-31491 : could not add logfile to LogMiner session
  • ora-25157 : Specified block size string is not valid
  • ora-16107 : all log data from primary has been processed
  • ora-06250 : NETNTT: cannot allocate send and receive buffers
  • ora-15045 : ASM file name 'string' is not in reference form
  • ora-02426 : privilege grant failed
  • ora-16753 : resource guard could not open standby database
  • ora-01212 : MAXLOGMEMBERS may not exceed string
  • ora-22810 : cannot modify object attributes with REF dereferencing
  • ora-06517 : PL/SQL: Probe error - 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.