Using Dbms_tts.transport_set_check Results in Entry in Transport_set_violations
(Doc ID 114915.1)
Last updated on MARCH 27, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 8.1.6 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
> Internal Only currency check done on 20/10/2016
- While using dbms_tts.transport_set_check to check a set of tablespaces for transport, a violation is recorded in the transport_set_violations view e.g. one of the following:
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>
- Both exp and expdp will error out with ORA-29341 if you attempt to export the transportable tablespace set with violations
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
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!