Sunday, June 27, 2010

EXP-00008: ORACLE error 29341 encountered

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