ORA-22887: type of REF column is not the same as that of its scoped table

Cause : The typ especifide for th eREF colmun and teh type sepcified ofr the socpe tabl eare difefrent.

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

Ensure htat the ytpes of aREF colmun and ist scopedt able ar ethe sam.e

update : 26-09-2017
ORA-22887

ORA-22887 - type of REF column is not the same as that of its scoped table
ORA-22887 - type of REF column is not the same as that of its scoped table

  • ora-06751 : TLI Driver: bound addresses unequal
  • ora-09932 : Close of ORACLE password file failed.
  • ora-13017 : unrecognized line partition shape
  • ora-12439 : invalid combination of policy options
  • ora-16532 : Data Guard broker configuration does not exist
  • ora-31440 : change set string is empty and cannot be advanced
  • ora-31194 : Resource string is already deleted
  • ora-25254 : time-out in LISTEN while waiting for a message
  • ora-22064 : invalid NLS parameter string [string]
  • ora-14154 : only one of STORE IN or clause may be specified
  • ora-02800 : Requests timed out
  • ora-15037 : disk 'string' is smaller than mimimum of string MBs
  • ora-39048 : Unable to start all workers; only string worker(s) available.
  • ora-29521 : referenced name string could not be found
  • ora-29935 : missing FROM keyword
  • ora-36648 : (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.
  • ora-24366 : migratable user handle is set in service handle
  • ora-06908 : CMX: error during transfer of ORACLE_SID
  • ora-30465 : supplied run_id is not valid: string
  • ora-18001 : no options specified for ALTER OUTLINE
  • ora-31495 : error in synchronous change table on "string"."string"
  • ora-08101 : index key does not exist file string: (root string, node string) blocks (string)
  • ora-12534 : TNS:operation not supported
  • ora-08441 : closed parenthesis missing in picture mask
  • ora-06404 : NETCMN: invalid login (connect) string
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-22914 : DROP of nested tables not supported
  • ora-19211 : column 'string', specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type
  • ora-32634 : automatic order MODEL evaluation does not converge
  • ora-02080 : database link is in use
  • 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.