Re: 10g and transportable tablespace on the same platform

SOLUTION

Step 1: export
sqlplus ${src_conn} EOF
create or replace directory dumpdir as '${dumpdir}'; alter tablespace $src_tablespace read only; EOF
expdp ${src_conn} dumpfile=$dumpfile directory=dumpdir transport_tablespaces="(${src_tablespace})"

sqlplus ${dest_conn} EOF
create or replace directory dumpdir as '${dumpdir}'; drop tablespace ${src_tablespace} INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
EOF Step 2: cold backup & dump file transfer scp ${oracle_storage}/${datafiles} ${dest_server}:${oracle_storage} scp ${dumpdir}/${dumpfile} ${dest_server}:${dumpdir}

Step 3: import
impdp ${dest_conn} dumpfile=$dumpfile directory=dumpdir transport_datafiles=${oracle_storage}/${datafiles} Received on Mon Oct 22 2007 - 14:01:14 CDT