Error ORA-29341 while transporting tablespace with Datapump (Doc ID 271984.1)

郑全

APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.0. to 12.1.0.1 [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 02-MAR-2010***


SYMPTOMS
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

The error ORA-29341 while transporting the tablespace with DataPump


The error occurs even if the tablespace can be transported and self contained

CHANGES


CAUSE
The object residing in the tablespace which is being transported has the dependent object in the SYSTEM tablespace.

The normal export works but the error occurs in case of datapump export.


The transportable_set_check does not have full check specified and normal transportable export does not do a full check but full check disallows in-pointer or references from outside of a transportable set into a transportable set.

Steps to reproduce the error:
~~~~~~~~~~~~~~~~~~~~~

connect "/as sysdba"

create or replace directory data_pump_dir as '/home/users/dump_files';

grant read,write on directory data_pump_dir to u1;

grant exp_full_database to u1;

connect u1/u1;

create table emp (emp_name varchar2(90));

create index emp_indx on emp (emp_name) tablespace system;

insert into emp values ('asdf');

insert into emp values ('fffd');

commit;


execute dbms_tts.transport_set_check ('USERS1',true);
PL/SQL procedure successfully completed.


select * from transport_set_violations;
no rows selected

exit

$ expdp u1/u1 DUMPFILE=acb.dmp TRANSPORT_TABLESPACES='USERS1' TRANSPORT_FULL_CHECK=y LOGFILE=expacb.log

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
Starting "U1"."SYS_EXPORT_TRANSPORTABLE_01": u1/******** DUMPFILE=acb.dmp TRANS
PORT_TABLESPACES=USERS1 TRANSPORT_FULL_CHECK=y LOGFILE=expacb.log
ORA-39123: Data Pump transportable tablespace job aborted
ORA-29341: The transportable set is not self-contained

Job "U1"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at 08:45
SOLUTION
Create the index in the same tablespace which is being transported or drop the index before transporting the tablespace.