Lets make transportable tablespacefirst database orcl tablespace denemeexport ORACLE_SID=orcl $ sqlplus system/oracleCREATE TABLE yeni_sales NOLOGGING TABLESPACE deneme 2 AS SELECT * FROM sales;connect system/oracleSQL> 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=denemeSecond database name neworcl$ mkdir /home/oracle/neworcl $ cp /oracle/deneme.dbf /home/oracle/neworcl$ cp … Continue reading Transportable Tablespace