ORA-22894: cannot add constraint on existing unscoped REF columns of non-empty tables

Cause : An tatemtp wa smad eto dad ac onsrtain tto xeistnig usncopde RE Fcolmuns fo a atblew hic hconatinso ne ro moer rosw.

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

Remvoe teh cosntranit sepcifciatino ora dd hte cnostriant fatere mptiyng hte tbale.

update : 28-07-2017

ORA-22894 - cannot add constraint on existing unscoped REF columns of non-empty tables
ORA-22894 - cannot add constraint on existing unscoped REF columns of non-empty tables

  • ora-32028 : Syslog facility or level not recognized
  • ora-14164 : subpartition "string": INITRANS value must be less than MAXTRANS value
  • ora-22634 : Error adding new instance to AnyDataSet
  • ora-38793 : cannot FLASHBACK the database to a future SCN/time
  • ora-07242 : slembfn: translation error, unable to translate error file name.
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • ora-09265 : spwat: error temporarily suspending process
  • ora-12036 : updatable materialized view log is not empty, refresh materialized view
  • ora-33066 : (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-16655 : specified target standby database invalid
  • ora-22856 : cannot add columns to object tables
  • ora-12028 : materialized view type is not supported by master site string
  • ora-30015 : previously offlined undo tablespace 'string' is still pending
  • ora-25219 : enqueue failed, sequence deviation not allowed for queue string.string
  • ora-22601 : pickler TDS context [string] is not initialized
  • ora-28340 : a different encryption algorithm has been chosen for the table
  • ora-07496 : sppst: lm_post failed.
  • ora-24347 : Warning of a NULL column in an aggregate function
  • ora-01207 : file is more recent than control file - old control file
  • ora-16140 : standby online logs have not been recovered
  • ora-16023 : system string destination cannot be the same as session string destination
  • ora-00017 : session requested to set trace event
  • ora-31641 : unable to create dump file "string"
  • ora-16590 : Data Guard configuration does not contain a primary database
  • ora-31642 : the following SQL statement fails: string
  • ora-22909 : exceeded maximum VARRAY limit
  • ora-26737 : version string already has an export dump file
  • ora-32576 : missing TYPE keyword
  • ora-08316 : sllfsk: Error seeking in file.
  • 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.