When I was going to export tablespace, I encountered following error:
Command to export:
C:\>EXP SYS/passwd transport_tablespace=Y tablespaces=(NAMUNA) LOG=C:\TEMP\NAMUNA.LOG FILE=C:\oracle\Backups\IMP_EXP\EXP_TBLSP_NAMUNA613251.DMP
Error:
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
The problem here is:
Tablespace contains the table owner by SYS.
To find out this problem:
SQL> exec dbms_tts.transport_set_check('NAMUNA', true, true);
PL/SQL procedure successfully completed.
SQL> select * from transport_set_violations;
VIOLATIONS
--------------------------------------------------------------------------------------
Sys owned object EMPL in tablespace NAMUNA not allowed in pluggable set
Solution:
SQL> drop table empl;
Table dropped.
Or, recreate by other user.
No comments:
Post a Comment