Error: ORA-39922: Default Partition (Index) Tablespace TBSXXX Not Contained In Transportable Set after Exchange Partition (Doc ID 2861220.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

After exchanging a partition including it's indexes, when running DBMS_TTS.TRANSPORT_SET_CHECK on the new non-partitioned table, you get this error:

SQL> EXECUTE SYS.DBMS_TTS.TRANSPORT_SET_CHECK('TBS1,TBS2',TRUE);

PL/SQL procedure successfully completed.

SQL> SELECT * FROM SYS.TRANSPORT_SET_VIOLATIONS;

VIOLATIONS
------------------------------------------------------------------------------------------------------------------------------------
ORA-39922: Default Partition (Index) Tablespace INDEX_TBS_1 for INDEX1 not contained in transportable set.

Where TBS1 is the tablespace for the new non-partitioned table, TBS2 is the new tablespaces for the index on the non-partitioned table.

And INDEX_TBS_1 is the tablespace for the index on the original Partitioned table.

Note that the Original table is NOT involved in the transport check. 

Changes

 Alter table exchange partition was executed.

Cause

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