Category Archives: transportable tablespace

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 … Continue reading

Posted in transportable tablespace | Leave a comment