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 : 29-05-2017

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

  • ora-07614 : $CHANGE_CLASS failed in retrieving the user's process label
  • ora-30980 : Invalid Input.
  • ora-15033 : disk 'string' belongs to diskgroup "string"
  • ora-38453 : ExpFilter index should be created in the same schema as the base table.
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-25269 : cant specify sognature with get signature option
  • ora-16637 : an instance failed to access the Data Guard broker configuration
  • ora-16566 : unsupported document type
  • ora-38707 : Media recovery is not enabled.
  • ora-12468 : max write level does not equal max read level
  • ora-26736 : Data Pump error
  • ora-19125 : fn:exactly-one() called with a sequence containing zero or more than one item
  • ora-00347 : log string of thread string, expected block size string doesn't match string
  • ora-13151 : failed to remove exception record
  • ora-29702 : error occurred in Cluster Group Service operation
  • ora-36830 : (XSLMGEN00) AW name cannot be NA
  • ora-19285 : FODC0002 - error retrieving resource
  • ora-16581 : Data Guard NetSlave failed to send message to DRCX
  • ora-07707 : error in archive text: need tape label name
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-38792 : encountered unknown flashback record from release string
  • ora-06112 : NETTCP: invalid buffer size
  • ora-25436 : invalid table alias: string
  • ora-01196 : file string is inconsistent due to a failed media recovery session
  • ora-31503 : invalid date supplied for begin_date or end_date
  • ora-01591 : lock held by in-doubt distributed transaction string
  • ora-25281 : complete reciever information not provided to non-repudiate reciever
  • ora-06251 : NETNTT: cannot translate address file name
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-30075 : TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint
  • 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.