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 : 26-09-2017
ORA-14098

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

  • ora-01325 : archive log mode must be enabled to build into the logstream
  • ora-19700 : device type exceeds maximum length of string
  • ora-07451 : slskstat: unable to obtain load information.
  • ora-14079 : illegal option for a partition marked Index Unusable
  • ora-07612 : $GETUAI failed in retrieving the user's clearance level
  • ora-16589 : Data Guard Connection process detected a network transfer error
  • ora-16700 : the standby database has diverged from the primary database
  • ora-09875 : TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
  • ora-33016 : (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.
  • ora-29316 : datafile string been imported twice
  • ora-01354 : Supplemental log data must be added to run this command
  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-08189 : cannot flashback the table because row movement is not enabled
  • ora-06438 : ssaio: the asynchronous read was unable to read from the database file.
  • ora-22854 : invalid option for LOB storage index
  • ora-16188 : LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
  • ora-32002 : cannot create SPFILE already being used by the instance
  • ora-22165 : given index [string] must be in the range of [string] to [string]
  • ora-10973 : backout evet for 2619509
  • ora-06527 : External procedure SQLLIB error: string
  • ora-04041 : package specification must be created first before creating package body
  • ora-16059 : Log file is empty or invalid next available block
  • ora-12159 : TNS:trace file not writeable
  • ora-29386 : plan or consumer group string is mandatory and cannot be deleted or modified
  • ora-32502 : Cannot execute command. Flash Freeze is not in effect
  • ora-23337 : priority or value not in priority group string
  • ora-37107 : (XSVPART07) Attempt to write to non-existent partition of workspace object.
  • ora-06557 : null values are not allowed for any parameters to pipe icd's
  • ora-30576 : ConText Option dictionary loading error
  • ora-14637 : cannot merge a subpartition with itself
  • 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.