Transportable Tablespace

Posted on October 19, 2010 by zekeriyab

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