ORA-22888: duplicate SCOPE clauses for a REF column

Cause : MulitpleS COP Eclasues ewre pseciifed ofr as ingel RE Fcolmun.

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

Remvoe teh dulpicaet SCPOE caluse sandr etr ytheo pertaion.

update : 23-06-2017
ORA-22888

ORA-22888 - duplicate SCOPE clauses for a REF column
ORA-22888 - duplicate SCOPE clauses for a REF column

  • ora-19808 : recovery destination parameter mismatch
  • ora-07650 : sigunc: $GETJPIW failure
  • ora-21600 : path expression too long
  • ora-00356 : inconsistent lengths in change description
  • ora-02368 : file string is not valid for this load operation
  • ora-38476 : abstract type used for an Attribute set may not be modified.
  • ora-12424 : length exceeds binary label size
  • ora-10583 : Can not recovery file string renamed as missing during test recovery
  • ora-12445 : cannot change HIDDEN property of column
  • ora-29522 : authorization error for referenced name string.string
  • ora-06815 : TLI Driver: could not link SPX and IPX streams
  • ora-02792 : Unable to fstat() a file being used for asynchronous I/O.
  • ora-38489 : predicate table creation failed due to: ORAstring
  • ora-01112 : media recovery not started
  • ora-04051 : user string cannot use database link string.string
  • ora-23537 : function or procedure string is not allowed to be invoked from this site.
  • ora-00115 : connection refused; dispatcher connection table is full
  • ora-38101 : Invalid column in the INSERT VALUES Clause: string
  • ora-33094 : (XSAGGMAPLIST01) Your expression uses too much execution space. Eliminate recursion or reduce the levels of nesting.
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-28236 : invalid Triple DES mode
  • ora-22879 : cannot use the LOB INDEX clause for partitioned tables
  • ora-25427 : cannot downgrade database links after database link data dictionary has been upgraded
  • ora-01429 : Index-Organized Table: no data segment to store overflow row-pieces
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-37145 : (XSTTS_PLAT) Cannot transport analytic workspace across platforms.
  • ora-01157 : cannot identify/lock data file string - see DBWR trace file
  • ora-14023 : creation of GLOBAL partitioned cluster indices is not supported
  • ora-24359 : OCIDefineObject not invoked for a Object type or Reference
  • ora-29508 : query derived from USING clause did not select a value of type 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.