ORA-14642 on ALTER TABLE EXCHANGE PARTITION (Doc ID 1389444.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.7 to 11.1.0.7 [Release 9.2 to 11.1]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Getting ORA-14642 in ALTER TABLE EXCHANGE PARTITION

SQL> create table pt (
2 no number(2) not null,
3 mytext1 char(10) not null,
4 no1 number(2)
5 ) partition by range(no) (
6 partition pt1 values less than (1) );

Table created.

SQL> create bitmap index ptidx1 on pt(no) local;

Index created.

SQL> alter table pt drop column no1;

Table altered.

SQL> alter table pt add (no1 number(2) default 0 not null);

Table altered.

SQL> create bitmap index ptidx2 on pt(no1) local;

Index created.


SQL> create table pt1 as select * from pt where 1=0;

Table created.

SQL> create bitmap index pt1idx1 on pt1(no);

Index created.

SQL> create bitmap index pt1idx2 on pt1(no1);

Index created.

SQL> alter table pt add partition pt2 values less than (2);

Table altered.

SQL> alter table pt exchange partition pt2 with table pt1 including indexes without validation;
alter table pt exchange partition pt2 with table pt1 including indexes without validation
*
ERROR at line 1:
ORA-14642: Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

Cause

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 hundreds of Community platforms