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 : 23-04-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-12419 : null binary label value
  • ora-06930 : CMX: error when checking ORACLE_SID
  • ora-23453 : requested operation is not supported on top flavor
  • ora-01292 : no log file has been specified for the current LogMiner session
  • ora-39091 : unable to determine logical standby and streams status
  • ora-01112 : media recovery not started
  • ora-28342 : integrity check fails on column key
  • ora-13019 : coordinates out of bounds
  • ora-27418 : syntax error in repeat interval or calendar
  • ora-01299 : dictionary string corresponds to a different database incarnation
  • ora-08430 : raw data missing leading sign
  • ora-28121 : driving context does not exist
  • ora-27506 : IPC error connecting to a port
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-13218 : max number of supported index tables reached for [string] index
  • ora-12164 : TNS:Sqlnet.fdf file not present
  • ora-29259 : end-of-input reached
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-02204 : ALTER, INDEX and EXECUTE not allowed for views
  • ora-25527 : bad format of _DB_MTTR_SIM_TARGET
  • ora-30434 : refresh method must be one of FC?AN, not 'string'
  • ora-04074 : invalid REFERENCING name
  • ora-24816 : Expanded non LONG bind data supplied after actual LONG or LOB column
  • ora-24792 : cannot mix services in a single global transaction
  • ora-22132 : hexadecimal string does not correspond to a valid REF
  • ora-19908 : datafile string has invalid checkpoint
  • ora-02027 : multi-row UPDATE of LONG column is not supported
  • ora-14458 : attempt was made to create a temporary table with INDEX organization
  • ora-28594 : agent control utility: invalid parameter name
  • ora-13048 : recursive SQL fetch error
  • 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.