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 : 30-04-2017

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

  • ora-01084 : invalid argument in OCI call
  • ora-12444 : policy already applied to table
  • ora-26000 : partition load specified but table string is not partitioned
  • ora-03218 : invalid option for CREATE/ALTER TABLESPACE
  • ora-32021 : parameter value longer than string characters
  • ora-12066 : invalid CREATE MATERIALIZED VIEW command
  • ora-02776 : Value for request done signal exceeds maximum
  • ora-21523 : functionality not supported by the server (object mode only)
  • ora-02706 : osnshs: host name too long
  • ora-14285 : cannot COALESCE the only partition of this hash partitioned table or index
  • ora-01781 : UNRECOVERABLE cannot be specified without AS SELECT
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-00080 : invalid global area specified by level string
  • ora-15185 : Could not close dynamic library string, error [string]
  • ora-12353 : secondary stored object cannot reference remote object
  • ora-10282 : Inhibit signalling of other backgrounds when one dies
  • ora-33452 : (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
  • ora-33336 : (DSSEXIST04A) Analytic workspace string is not attached.
  • ora-01572 : rollback segment 'string' cannot be brought online, string extents exceeded
  • ora-06951 : Operating system call error
  • ora-31208 : DBMS_LDAP: PL/SQL - Invalid LDAP Message.
  • ora-09943 : Allocation of memory for password list component failed.
  • ora-16775 : target standby database in broker operation has potential data loss
  • ora-25279 : dequeue as select not supported before 8.2
  • ora-25102 : PARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-30509 : client logoff triggers cannot have AFTER type
  • ora-02707 : osnacx: cannot allocate context area
  • ora-36902 : (XSAGDNGL43) In AGGMAP workspace object, the MODEL workspace object is not a model over a base dimension of the AGGMAP.
  • ora-29856 : error occurred in the execution of ODCIINDEXDROP routine
  • ora-31651 : communication error with master process - detaching job
  • 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.