Transportable tablespace becomes non-transportable
597802Jan 16 2008 — edited Jan 16 2008Dear 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!