Transportable Tablespace

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





Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s