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 : 22-09-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-24771 : cannot detach, prepare or forget a local transaction
  • ora-31153 : Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"
  • ora-01144 : File size (string blocks) exceeds maximum of string blocks
  • ora-30945 : Could not create mapping table 'string'
  • ora-16621 : database name for ADD DATABASE must be unique
  • ora-13123 : invalid name specified
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-00091 : LARGE_POOL_SIZE must be at least string
  • ora-00105 : too many dispatcher configurations
  • ora-02281 : duplicate or conflicting CACHE/NOCACHE specifications
  • ora-27068 : I/O buffer is not aligned properly
  • ora-22344 : can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
  • ora-29373 : resource manager is not on
  • ora-02255 : obsolete 7.1.5
  • ora-30439 : refresh of 'string.string' failed because of string
  • ora-07801 : slbtpd: invalid exponent
  • ora-01177 : data file does not match dictionary - probably old incarnation
  • ora-13516 : AWR Operation failed: string
  • ora-38610 : FI "string" name prefix is reserved for frequent itemset counting
  • ora-10641 : Cannot find a rollback segment to bind to
  • ora-02761 : File number to be canceled is negative.
  • ora-12318 : database (link name string) is already mounted
  • ora-39006 : internal error
  • ora-00480 : LCK* process terminated with error
  • ora-02460 : Inappropriate index operation on a hash cluster
  • ora-01690 : sort area size too small
  • ora-16771 : failover to a physical standby database failed
  • ora-31435 : an error occurred during the purge operation
  • ora-23451 : flavor string already defined for object group "string"."string"
  • ora-31103 : Resource locked in shared mode. Cannot add exclusive lock
  • 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.