ORA-14297: Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

Cause : The block sizes of a pair of indexes being exchanged in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are different.

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

Ensure that the block sizes of the corresponding pairs of indexes that need to be exchanged in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are the same.

update : 29-04-2017
ORA-14297

ORA-14297 - Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
ORA-14297 - Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

  • ora-06771 : TLI Driver: error reading version
  • ora-13484 : the file format and/or compression type is not supported
  • ora-27203 : skgfpqb: sbtpcquerybackup returned error
  • ora-29852 : keyword IS is missing
  • ora-19614 : archivelog thread string sequence string not found in backup set
  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-30116 : syntax error at 'string' following 'string'
  • ora-19287 : XP0017 - invalid number of arguments to function - string:string
  • ora-13448 : GeoRaster metadata BRS error
  • ora-31603 : object "string" of type string not found in schema "string"
  • ora-14613 : Attempt to generate name from parent name string and template name string failed as the combine named would have been longer than allowed
  • ora-01656 : max # extents (string) reached in cluster string.string
  • ora-14605 : Name missing for subpartition / lob segment in template
  • ora-12455 : internal error in Label Security MMON cleanup task
  • ora-25105 : RECOVERABLE option can only be used with ALTER INDEX REBUILD
  • ora-31513 : unsupported column type specified in change table
  • ora-29968 : No primary operator bindings found for ancillary binding #string
  • ora-02212 : duplicate PCTFREE option specification
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-26697 : LCR contains extra column 'string'
  • ora-09270 : szalloc: error allocating memory for security
  • ora-09206 : sfrfb: error reading from file
  • ora-19731 : cannot apply change to unverified plugged-in datafile string
  • ora-02420 : missing schema authorization clause
  • ora-25252 : listen failed, the address string is a non-persistent queue
  • ora-02043 : must end current transaction before executing string
  • ora-09341 : scumnt: unable to mount database
  • ora-13369 : invalid value for etype in the 4-digit format
  • ora-02848 : Asynchronous I/O package is not running
  • 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.