About Me

Database and GIS Consultant.

Friday, June 4, 2010

ORA-29341: The transportable set is not self-contained

H:\>exp 'sys/****@db5 as sysdba' parfile=Z:\DATA_NORTH_TBSP_EXP.PAR

Export: Release 10.2.0.3.0 - Production on Fri Jun 4 15:14:40 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported
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


SYS@db5> EXECUTE dbms_tts.transport_set_check('DATA_NORTH', TRUE, TRUE);

PL/SQL procedure successfully completed.

SYS@db5> SELECT * FROM transport_set_violations;

VIOLATIONS
----------------------------------------------------------------------------------------------------
Index EGIS_RW_X.SDE_RIX_113 in tablespace DATA_NORTH points to table EGIS_RW_X.DATA_SOUTH
SOUTH

SYS@db5> ALTER INDEX EGIS_RW_X.SDE_RIX_113 REBUILD TABLESPACE DATA_SOUTH;

Index altered.

SYS@db5> SELECT * FROM transport_set_violations;

VIOLATIONS
----------------------------------------------------------------------------------------------------
Index EGIS_RW_X.SDE_RIX_113 in tablespace DATA_NORTH points to table EGIS_RW_X.DATA_SOUTH
SOUTH


SYS@db5> EXECUTE dbms_tts.transport_set_check('DATA_NORTH', TRUE, TRUE);

PL/SQL procedure successfully completed.

SYS@db5> SELECT * FROM transport_set_violations;

no rows selected


H:\exp 'sys/****@db5 as sysdba' parfile=Z:\DATA_NORTH_TBSP_EXP.PAR

Export: Release 10.2.0.3.0 - Production on Fri Jun 4 15:20:11 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
For tablespace DATA_NORTH ...
. exporting cluster definitions
. exporting table definitions
. . exporting table DATA_NORTH
. . exporting table SDE_RAS_81
. . exporting table SDE_BND_81
. . exporting table SDE_AUX_81
. . exporting table SDE_BLK_81
. . exporting table F85
. . exporting table S85
. exporting referential integrity constraints
. exporting triggers
. end transportable tablespace metadata export
Export terminated successfully without warnings.