Lets make transportable tablespace


first database orcl tablespace deneme


export ORACLE_SID=orcl

$ sqlplus system/oracle


CREATE TABLE yeni_sales NOLOGGING TABLESPACE deneme

2 AS SELECT * FROM sales;


connect system/oracle

SQL> ALTER TABLESPACE deneme READ ONLY


$ mkdir /home/oracle/orcl

$ sqlplus system/oracle

SQL> CREATE DIRECTORY orcl_dir as ‘/home/oracle/orcl’;


$ expdp system/oracle DIRECTORY=orcl_dir DUMPFILE=yeni_sales.dmp TRANSPORT_TABLESPACES=deneme


Second database name neworcl

$ mkdir /home/oracle/neworcl $ cp /oracle/deneme.dbf /home/oracle/neworcl

$ cp /home/oracle/orcl/yeni_sales.dmp /home/oracle/neworcl


export ORACLE_SID=neworcl

$ sqlplus system/oracle


SQL> create directory new_dir as ‘/home/oracle/neworcl’;


$ impdp system/oracle DIRECTORY=new_dir DUMPFILE=yeni_sales.dmp logfile=yeni.log transport_datafiles=/home/oracle/neworcl/deneme.dbf