My Oracle Support Banner

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

Last updated on APRIL 07, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

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

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

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


In this Document
Symptoms
Changes
Cause
Solution


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