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 : 23-06-2017

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-16794 : database guard is on for primary database
  • ora-19729 : File string is not the initial version of the plugged in datafile
  • ora-28176 : incorrect certificate version
  • ora-00339 : archived log does not contain any redo
  • ora-19690 : backup piece release string incompatible with Oracle release string
  • ora-13621 : The task_or object string is marked as a template and cannot perform the requested operation.
  • ora-39109 : Unprivileged users may not operate upon other users' schemas
  • ora-24306 : bad buffer for piece
  • ora-02758 : Allocation of internal array failed
  • ora-00233 : copy control file is corrupt or unreadable
  • ora-08114 : can not alter a fake index
  • ora-22921 : length of input buffer is smaller than amount requested
  • ora-22620 : buffer size too small to hold the value
  • ora-24007 : invalid value string, MAX_RETRIES should be non-negative integer
  • ora-06579 : Bind variable not big enough to hold the output value
  • ora-16725 : the phase supplied to resource guard is invalid
  • ora-31422 : owner schema string does not exist
  • ora-28595 : Extproc agent : Invalid DLL Path
  • ora-29810 : inadequate operator privileges
  • ora-12733 : regular expression too long
  • ora-07284 : sksaprd: volume size specification not terminated properly.
  • ora-24392 : no connection pool to associate server handle
  • ora-38906 : insert into DML Error Logging table "string" failed
  • ora-31195 : XML node 'string' (type=string) does not support this operation
  • ora-25276 : table specified is not a queue table
  • ora-00911 : invalid character
  • ora-26097 : unsupported conversion for column string (from type number to type number)
  • ora-30515 : suspend triggers cannot have BEFORE type
  • ora-02730 : osnrnf: cannot find user logon directory
  • ora-25278 : grantee name cannot be NULL
  • 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.