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-04-2017

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

  • ora-21602 : operation does not support the specified typecode
  • ora-28001 : the password has expired
  • ora-07672 : $PARSE_CLASS failed translating the string into a binary label
  • ora-06108 : NETTCP: connect to host failed
  • ora-31689 : illegal value for base worker id, string
  • ora-16081 : insufficient number of processes for APPLY
  • ora-29391 : %s and string must be mandatory to create a mandatory plan directive
  • ora-29862 : cannot specify FORCE option for dropping non-domain index
  • ora-33098 : (APABBR01) A value of 'string' is not valid for the workspace object option.
  • ora-28274 : No ORACLE password attribute corresponding to user nickname exists.
  • ora-30193 : reserved for future use
  • ora-12159 : TNS:trace file not writeable
  • ora-31657 : data filter name can not be defaulted
  • ora-39123 : Data Pump transportable tablespace job aborted string
  • ora-14096 : tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
  • ora-14645 : STORE IN clause cannot be specified for Range List objects
  • ora-13703 : The snapshot pair [string, string] for database_id string and instance_id string are not found in the current repository.
  • ora-03130 : the buffer for the next piece to be fetched is required
  • ora-28506 : parse error in data dictionary translation for string stored in string
  • ora-27374 : insufficient privileges on event source queue
  • ora-31224 : DBMS_LDAP: invalid LDAP session
  • ora-23383 : registration for materialized view repgroup "string"."string" failed at site string
  • ora-01453 : SET TRANSACTION must be first statement of transaction
  • ora-10619 : Avoid assertions when possible
  • ora-16602 : object must be disabled to perform this operation
  • ora-30161 : A system error occurred during the OCIFile function call
  • ora-39035 : Data filter string has already been specified.
  • ora-08113 : composite partition index may not be compressed
  • ora-27141 : invalid process ID
  • ora-23449 : missing user name
  • 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.