My Oracle Support Banner

Alter Table Exchange Partition fails with errors ORA-14642 or ORA-14643 (Doc ID 248634.1)

Last updated on FEBRUARY 17, 2024

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Oracle Server - Enterprise Edition (with Partitioning Option, Bitmap Index Option)
Alter table exchange partition fails:
ORA-14642: Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
ORA-14643: Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION

Changes

Possible changes are:

1. Partitioned or non-partitioned table was Compressed or Uncompressed
2. One of the tables has been altered by command: 'Alter Table <table_name>;
   Minimize Records_per_block' or 'Alter Table <table_name> Nominimize Records_per_block'.
3. Table has been modified by adding Not Null Constraints

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.