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 : 29-04-2017
ORA-14281

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

  • ora-39097 : Data Pump job encountered unexpected error string
  • ora-19641 : backup datafile checkpoint is SCN string time string
  • ora-39213 : Metadata processing is not available
  • ora-32733 : Error occurred when executing Parallel Oradebug
  • ora-16026 : parameter string contains an invalid attribute value
  • ora-24384 : Application context size is not initialized
  • ora-02762 : file number to be cancelled is greater than the maximum.
  • ora-36961 : Oracle OLAP is not available.
  • ora-24059 : invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string
  • ora-14627 : Invalid operation was specified on a GLOBAL partitioned index
  • ora-12162 : TNS:net service name is incorrectly specified
  • ora-33267 : (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it
  • ora-26030 : index string.string had string partitions made unusable due to:
  • ora-16150 : FINISH recovery performed on another, older standby database
  • ora-01672 : control file may be missing files or have extra ones
  • ora-09939 : Restoration of signal handlers failed.
  • ora-06416 : NETCMN: error on test
  • ora-01681 : max # extents (string) reached in LOB segment in tablespace string
  • ora-39076 : cannot delete job string for user string
  • ora-27074 : unable to determine limit for open files
  • ora-27158 : process control failure
  • ora-27063 : number of bytes read/written is incorrect
  • ora-12824 : INSTANCES DEFAULT may not be specified here
  • ora-14507 : partition corrupt. all rows do not fall within partition bounds
  • ora-01198 : must specify size for log file if RESETLOGS
  • ora-26689 : column datatype mismatch in LCR
  • ora-13802 : failed to purge SQL Tuning Base entry from sql$
  • ora-12168 : TNS:Unable to contact LDAP Directory Server
  • ora-10360 : enable dbwr consistency checking
  • ora-36885 : (XSSRF04) Error rewriting OLAP DML expression. Column name too big
  • 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.