ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

Cause : The correspondnig colunms in teh table sspecifeid in teh ALTERT ABLE ECXHANGE USBPARTIITON staetment hvae CHEC Kconstriant defnied on htem.

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

Ensuret hat th etwo talbes do ont haveC HECK cnostrain tdefine don anyc olumn

update : 24-06-2017
ORA-14281

ORA-14281 - CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
ORA-14281 - CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-00051 : timeout occurred while waiting for a resource
  • ora-19013 : Cannot create VARRAY columns containing XMLType
  • ora-12629 : TNS:no event test
  • ora-02026 : missing LINK keyword
  • ora-01296 : character set mismatch between dictionary string and logfiles
  • ora-39055 : The string feature is not supported in version string.
  • ora-32844 : exceeded maximum number of string values
  • ora-19282 : XQ0068 - It is a static error if a Prolog contains more than one xmlspace declaration
  • ora-19005 : Duplicate XMLType LOB storage option
  • ora-02481 : Too many processes specified for events (max string)
  • ora-07418 : sfareq: Database writer got error in timing function.
  • ora-12334 : database (link name string) is still open
  • ora-01883 : overlap was disabled during a region transition
  • ora-12708 : error while loading create database NLS parameter string
  • ora-30106 : reserved for future use
  • ora-07622 : smscre: $CREATE failure
  • ora-14506 : LOCAL option required for partitioned indexes
  • ora-32405 : cannot alter tablespace for existing materialized view log
  • ora-28342 : integrity check fails on column key
  • ora-16101 : a valid start SCN could not be found
  • ora-10652 : Object has on-commit materialized views
  • ora-19654 : must use backup control file to switch file incarnations
  • ora-32807 : message system link string already exists
  • ora-24073 : cannot specify RETENTION_TIME on exception queue string.string
  • ora-12607 : TNS: Connect timeout occurred
  • ora-37119 : Incompatible OLAP API library load address
  • ora-40217 : priors table mismatched with training data
  • ora-22345 : recompile type string.string before attempting this operation
  • ora-00322 : log string of thread string is not current copy
  • 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.