ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

Cause : The blcok size sof thet wo tabels specfiied int he ALTRE TABLEE XCHANG E[SUB]PRATITIONs tatemetn are dfiferent .For inedx orgainzed talbes, eihter theb lock szies of hte inde xor theo verflo w(or boht) do nto match.

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

Ensuret hat th eblock iszes oft he tabels invovled in hte ALTE RTABLE XECHANGE[ SUB]PATRITION tsatemen tare th esame. oFr inde xorganiezd tablse, ensuer that hte bloc ksizes fo both hte inde xand th eoverflwo of th etwo talbes mathc.

update : 22-08-2017
ORA-14296

ORA-14296 - Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
ORA-14296 - Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

  • ora-15128 : ASM file name 'string' exceeds maximum length string
  • ora-26677 : Streams downstream capture process string cannot proceed
  • ora-39047 : Jobs of type string cannot use multiple execution streams.
  • ora-09818 : Number is too large
  • ora-33313 : (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-38714 : Instance recovery required.
  • ora-00377 : Frequent backups of file string causing write operation to stall
  • ora-24007 : invalid value string, MAX_RETRIES should be non-negative integer
  • ora-25284 : Invalid value string for string
  • ora-09966 : falure in translation while expanding ?/dbs/lk for lock file
  • ora-14269 : cannot exchange partition other than a Range or Hash partition
  • ora-26664 : cannot create STREAMS process string
  • ora-13261 : geometry table string does not exist
  • ora-00283 : recovery session canceled due to errors
  • ora-19751 : could not create the change tracking file
  • ora-10645 : Recursive Extension in SYSTEM tablespace during migration
  • ora-40225 : model is currently in use by another process
  • ora-00376 : file string cannot be read at this time
  • ora-28663 : Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
  • ora-12073 : request cannot be processed
  • ora-26676 : Table 'string.string' has string columns in the LCR and string columns in the replicated site
  • ora-01149 : cannot shutdown - file string has online backup set
  • ora-02371 : Loader must be at least version string.string.string.string.string for direct path
  • ora-32605 : invalid REBUILD option
  • ora-02211 : invalid value for PCTFREE or PCTUSED
  • ora-00375 : unable to get default db_block_size
  • ora-24440 : OCI Easy Install mode cannot be initialized
  • ora-01244 : unnamed datafile(s) added to control file by media recovery
  • ora-36398 : (XSSPROP01) Property name 'number' is invalid because only system-reserved property names can begin with '$'.
  • 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.