ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION

Cause : Thet wo atble sspeicfie din hte ATLER ATBLEE XCHNAGE USBPATRITINO haev inedxesw hic haren ot qeuivlaent

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

Ensrue taht teh inedxesf or hte tow talbes ahve nidexse whcih flolowt hisr uleF or veeryn on aprtiitone dindxe fo rthen on aprtiitone dtabel, tehre ahs t obe na idneticla LOACL idnex no th eparittioend tbale nad vcie vresa.B y iedntiacl, hte cloumnp osiiton,t ypea nd isze ahve ot bet he asme.

update : 24-07-2017
ORA-14279

ORA-14279 - index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION
ORA-14279 - index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION

  • ora-16742 : the standby database "string" has exhausted its quota
  • ora-12729 : invalid character class in regular expression
  • ora-12528 : TNS:listener: all appropriate instances are blocking new connections
  • ora-01648 : log string is the current log of disabled instance string (thread string)
  • ora-24790 : cannot mix OCI_TRANS_RESUME and transaction isolation flags
  • ora-01042 : detaching a session with open cursors not allowed
  • ora-14183 : TABLESPACE DEFAULT can be specified only for Composite LOCAL index
  • ora-15014 : location 'string' is not in the discovery set
  • ora-14031 : partitioning column may not be of type LONG or LONG RAW
  • ora-32060 : channel failure
  • ora-29293 : A stream error occurred during compression or uncompression.
  • ora-30041 : Cannot grant quota on the tablespace
  • ora-27421 : usage of string not supported in a calendar definition
  • ora-24331 : user buffer too small
  • ora-29522 : authorization error for referenced name string.string
  • ora-25009 : Nested table clause allowed only for INSTEAD OF triggers
  • ora-16739 : redo transport service for standby database "string" unexpectedly online
  • ora-19248 : XQ0028 - invalid node in document constructor
  • ora-29894 : base or varray datatype does not exist
  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-33425 : (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.
  • ora-30510 : system triggers cannot be defined on the schema of SYS user
  • ora-32027 : There is no string column with the matching type in string.string.
  • ora-02340 : invalid column specification
  • ora-00352 : all logs for thread string need to be archived - cannot enable
  • ora-27052 : unable to flush file data
  • ora-37077 : (XSMCSESS05) Object workspace object is specified more than once.
  • ora-38601 : FI Not enough memory for frequent itemset counting: string
  • ora-24055 : cannot delete propagation status rows that are in prepared state
  • ora-30190 : reserved for future use
  • 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.