Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Transportable tablespace becomes non-transportable

597802Jan 16 2008 — edited Jan 16 2008
Dear Guru's,

For years we exported and imported our transportable tablespaces, but recently the export fails with the following error message:

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

We use Oracle9i in RedHat 3.4 on xSeries 336 machine.

The exporting command: exp parfile=export.f

Contents of export.f:

USERID="/ as sysdba"
TRANSPORT_TABLESPACE=y
TABLESPACES=JAFFA_TSB,BLOB_TSP
# Outcommented lines contains default value:
#GRANTS=Y
#CONSTRAINTS=Y
#TRIGGERS=Y
#INDEXES=Y
TTS_FULL_CHECK=TRUE
OBJECT_CONSISTENT=Y
STATISTICS=COMPUTE
FILE=syn_meta.dmp
LOG=syn_meta.log

These attempts were made:
EXECUTE dbms_tts.transport_set_check('BLOB_TSP', TRUE, TRUE);
SELECT * FROM transport_set_violations ==> "no rows selected"

Oracle support service has still no answer to this issue.

How can we find where the problem is? Can anybody help?

Thanks a lot in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2008
Added on Jan 16 2008
2 comments
320 views