Using Dbms_tts.transport_set_check Results in Entry in Transport_set_violations (Doc ID 114915.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.6.1 to 11.2.0.2 [Release 8.1.6 to 11.2]
Information in this document applies to any platform.
> Internal Only currency check done on 20/10/2016

Symptoms

ORA-39921 Default Partition () Tablespace for not contained in transportable set  (where object_type either 'Table' or 'Index')
Index <index name> in tablespace <tbs to be transported> points to table <table name> in tablespace <other tbs>

expdp

Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01":  system/******** DUMPFILE=ttsa.dmp DIRECTORY=EIF TRANSPORT_TABLESPACES=ttsa

ORA-39123: Data Pump transportable tablespace job aborted
ORA-29341: The transportable set is not self-contained

Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at 13:50:41


exp

About to export transportable tablespace metadata...

EXP-00008: ORACLE error 29341 encountered
ORA-29341: The transportable set is not self-contained
ORA-06512: at "SYS.DBMS_PLUGTS", line 1387
ORA-06512: at line 1

EXP-00000: Export terminated unsuccessfully

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