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 : 27-04-2017
ORA-12991

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

  • ora-01868 : the leading precision of the interval is too small
  • ora-13361 : not enough sub-elements within a compound ETYPE
  • ora-10567 : Redo is inconsistent with data block (file# string, block# string)
  • ora-26023 : index string.string partition string was made unusable due to:
  • ora-22819 : scope of input value does not correspond to the scope of the target
  • ora-16033 : parameter string destination cannot be the same as parameter string destination
  • ora-06754 : TLI Driver: unable to get local host address
  • ora-02732 : osnrnf: cannot find a matching database alias
  • ora-27453 : %s is an invalid job or program argument name.
  • ora-19583 : conversation terminated due to error
  • ora-25149 : Columns of UROWID type may not be indexed
  • ora-24396 : invalid attribute set in server handle
  • ora-10630 : Illegal syntax specified with SHRINK clause
  • ora-30088 : datetime/interval precision is out of range
  • ora-02044 : transaction manager login denied: transaction in progress
  • ora-23419 : regenerate replication support before resuming master activity
  • ora-08311 : sllfop: bad value for maxrecsize
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • ora-22630 : attribute [string] is null or it is not well-formed
  • ora-24853 : failed to connect thread to shared subsystem
  • ora-27021 : sequential file handle must be specified
  • ora-12732 : invalid interval value in regular expression
  • ora-38408 : The ADT "string" does not exist in the current schema.
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-25302 : Operation not possible for non-buffered queue string
  • ora-12651 : Encryption or data integrity algorithm unacceptable
  • ora-03277 : invalid SIZE specified
  • ora-29277 : invalid SMTP operation
  • ora-28116 : insufficient privileges to do direct path access
  • ora-31624 : A job cannot be modified after it has started.
  • 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.