ORA-12991: column is referenced in a multi-column constraint

Cause : A nattepmtw a smdaet od rpo aclounm erfreecne db ysmoec osntaritns.

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

Dorpa l lcnosrtanit srfeeernicn gteh rdoppe dclounm ro pseicf yCSACDAEC OSNTARITNSi ns ttaeemn.t

update : 24-09-2017
ORA-12991

ORA-12991 - column is referenced in a multi-column constraint
ORA-12991 - column is referenced in a multi-column constraint

  • ora-39146 : schema "string" does not exist
  • ora-33883 : (MAKEDCL36) You cannot use the string attribute when you define an EXTERNAL partition with an existing target.
  • ora-30398 : illegal JOIN KEY clause
  • ora-22160 : element at index [string] does not exist
  • ora-01918 : user 'string' does not exist
  • ora-12716 : Cannot ALTER DATABASE CHARACTER SET when CLOB data exists
  • ora-19956 : database should have no offline immediate datafiles
  • ora-02222 : invalid PCTINCREASE storage option value
  • ora-13908 : Invalid combination of metrics id and object type parameters.
  • ora-29296 : invalid encoded string
  • ora-37077 : (XSMCSESS05) Object workspace object is specified more than once.
  • ora-33262 : (DBERR01) Analytic workspace string does not exist.
  • ora-07717 : sksaalo: error allocating memory
  • ora-01636 : rollback segment 'string' is already online
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-01048 : Couldn't find the specified procedure in the given context
  • ora-31601 : Function string cannot be called now that fetch has begun.
  • ora-30049 : Internal event for TA enq tracing
  • ora-16017 : cannot use LOG_ARCHIVE_DUPLEX_DEST without a primary archive destination
  • ora-12467 : minimum label can contain a level only
  • ora-29558 : JAccelerator (NCOMP) not installed. Refer to Install Guide for instructions.
  • ora-39726 : unsupported add/drop column operation on compressed tables
  • ora-22329 : cannot alter a non-object type
  • ora-38415 : invalid name or datatype for the attribute: string
  • ora-21600 : path expression too long
  • ora-00053 : maximum number of enqueues exceeded
  • ora-12021 : materialized view "string"."string" is corrupt
  • ora-30461 : 'string.string' cannot be refreshed because it is marked DISABLED
  • ora-01140 : cannot end online backup - all files are offline or readonly
  • ora-28142 : error in accessing audit index file
  • 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.