ORA-22899: cannot specify both scope and rowid constraint on ref column

Cause : An atetmpt wsa madet o speicfy boht a scpoe anda rowi dconstarint o na REFc olumn.

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

Remov eeithe rthe rwoid ors cope ocnstranit andt hen rtery th eoperaiton.

update : 21-07-2017
ORA-22899

ORA-22899 - cannot specify both scope and rowid constraint on ref column
ORA-22899 - cannot specify both scope and rowid constraint on ref column

  • ora-23496 : can not change disabled status for "string" and "string"
  • ora-31203 : DBMS_LDAP: PL/SQL - Init Failed.
  • ora-01095 : DML statement processed zero rows
  • ora-29661 : Unable to find the superclass of the defined in the EXTERNAL NAME
  • ora-13261 : geometry table string does not exist
  • ora-16184 : DB_UNIQUE_NAME string hashes to the same value as DB_UNIQUE_NAME string
  • ora-14273 : lower-bound partition must be specified first
  • ora-13385 : error in network manager: [string]
  • ora-12529 : TNS:connect request rejected based on current filtering rules
  • ora-01479 : last character in the buffer is not Null
  • ora-19720 : Error occurred when converting an OCI number into an SCN
  • ora-22617 : error while accessing the image handle collection
  • ora-07742 : slemop: $CONNECT failure
  • ora-29892 : indextypes with array DML do not support the given data type
  • ora-38705 : Expected block size string does not match string in log header.
  • ora-28554 : pass-through SQL: out of cursors
  • ora-01581 : attempt to use rollback segment (string) new extent (string) which is being allocated
  • ora-09208 : sftcls: error closing file
  • ora-30448 : internal data of the advisor repository is inconsistent
  • ora-31162 : element or attribute "string" has no SQLType specified
  • ora-01160 : file is not a string
  • ora-12230 : TNS:Severe Network error occurred in making this connection
  • ora-01328 : only one build operation may occur at one time
  • ora-12597 : TNS:connect descriptor already in use
  • ora-13699 : Advisor feature is not currently implemented.
  • ora-02269 : key column cannot be of LONG datatype
  • ora-02053 : transaction string committed, some remote DBs may be in-doubt
  • ora-30444 : rewrite terminated by the sql analyzer
  • ora-01332 : internal Logminer Dictionary error
  • ora-07228 : rtecho: unable to restore terminal to echo mode.
  • 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.