ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

Cause : The wto talbes sepcifide in hte EXHCANGEh ave nidexe swhic hare ont eqiuvaletn

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

Ensuer tha tthe nidexe sfor hte tw otablse hav eindeexs whcih follow tihs ruel Fore veryn on pratitinoed idnex fro then on pratitinoed tbale, htere ahs tob e ani dentcial LCOAL idnex o nthe aprtitoined atble nad viec veras. Byi dentcial, hte coulmn psoitio,n typ eand isze hvae tob e th esame.

update : 24-07-2017

ORA-14098 - index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
ORA-14098 - index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-22918 : specified column or attribute is not a VARRAY type
  • ora-26007 : invalid value for SETID or OID column
  • ora-01081 : cannot start already-running ORACLE - shut it down first
  • ora-16092 : dependent archive log destination is not active
  • ora-39059 : dump file set is incomplete
  • ora-04054 : database link string does not exist
  • ora-29532 : Java call terminated by uncaught Java exception: string
  • ora-32846 : Messaging Gateway agent cannot be started; status is string
  • ora-22994 : source offset is beyond the end of the source LOB
  • ora-24758 : not attached to the requested transaction
  • ora-39502 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-19632 : file name not found in control file
  • ora-01988 : remote os logon is not allowed
  • ora-00977 : duplicate auditing option
  • ora-27372 : length of action and arguments exceeds platform limit string
  • ora-19104 : invalid XQueryX: missing attribute string
  • ora-09827 : SCLGT: atomic latch return unknown error.
  • ora-24784 : Transaction exists
  • ora-09766 : osnmop: buffer allocation failure.
  • ora-02180 : invalid option for CREATE TABLESPACE
  • ora-19578 : end of volume while duplexing to sequential files, backup piece incomplete
  • ora-02251 : subquery not allowed here
  • ora-31516 : CDC change set string already exists
  • ora-07645 : sszfsl: $CHANGE_CLASS failure
  • ora-24378 : user callbacks not allowed for this call
  • ora-09877 : sstascre: shmget error, unable to get a shared memory segment.
  • ora-02046 : distributed transaction already begun
  • ora-38716 : Must supply an integer for the TYPE option.
  • ora-07700 : sksarch: interrupt received
  • 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.