Oracle Database Discussions

I'm soliciting your advise/help to solve my problems in EXP/IMP of TRANSPORTABLE TABLESPACE.

Here are the steps I do and corresponding errors:

@source:
1. Set tablespaces for transport read-only
alter tablespace "TABLESPACE" read only;

2. Export metadata of tablespaces for transport using user with DBA role

exp user/password@dB file=FILE_1.DMP TRANSPORT_TABLESPACE=Y tablespaces=TABLESPACE_1
TRIGGERS=n CONSTRAINTS=n

exp user/password@dB file=FILE_2.DMP TRANSPORT_TABLESPACE=Y tablespaces=TABLESPACE_2
TRIGGERS=n CONSTRAINTS=n

***error during export TABLESPACE_2***
ORA-29341: the transportable set is not self-contained

3. Physically copy exported files and datafiles to target

@target:
Created User having these privileges and run the following:
a) DBA
b) CREATE SESSION
c) CREATE Privs on imported objects
d) IMP_FULL_DATABASE
e) Execute privileges on the DBMS_RLS package
f) Run the CATEXP.SQL OR CATALOG.SQL scripts

4. Import metadata of transportable tablespaces

imp user/password@dB file=FILE_1.DMP TRANSPORT_TABLESPACE=y
datafiles=DIRECTORY OF CORRESPONDING DATAFILE

imp user/password@dB file=FILE_2.DMP TRANSPORT_TABLESPACE=y
datafiles=DIRECTORY OF CORRESPONDING DATAFILE

***error during import of both dmp files***
PLS-00201: identifier 'string' must be declared

Arnel Ca�on