Exchange partition of nested tables fails with ORA-14098 including indexes (Doc ID 2604952.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

As an example:

create type type1 is object(a number)
/

create type type2 as table of type1
/

create table test1
(f1 number,
f2 date,
f3 type2) tablespace <ts name>
nested table f3 store as f3
return as value
partition by range (f2)
(partition p1 values less than (TO_DATE(' 2011-09-21 00:00:00', 'SYYYY-MM-DD
HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
partition p2 VALUES LESS THAN (TO_DATE(' 2011-09-26 00:00:00', 'SYYYY-MM-DD
HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
partition maxpart values less than (maxvalue))
/

insert into test1
values(1,to_date('2011-09-10','YYYY-MM-DD'),null);
commit;

create table test2
nested table f3 store as t3
as select * from test1;

alter table test1
exchange partition p1 with table test2
including indexes without validation UPDATE GLOBAL INDEXES noparallel
SQL:prtyfundgd:>/
alter table test1
*
ERROR at line 1:
ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

Cause

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