Wednesday, December 7, 2016

export oracle schema ubuntu

*catatan oracle xe sudah terinstall di Ubuntu

Sebelum export setting environment terlebih dahulu :
Edit file .bashrc file to include the lines:
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export ORACLE_SID=XE

export PATH
setelah itu, bisa jalankan sbb:

The following examples demonstrate how the imp/exp utilities can be used:
exp scott/tiger file=emp.dmp log=emp.log tables=emp rows=yes indexes=no
exp scott/tiger file=emp.dmp tables=(emp,dept)
imp scott/tiger file=emp.dmp full=yes
imp scott/tiger file=emp.dmp fromuser=scott touser=scott tables=dept
atau bila connect melalui tns bisa sbb :

exp username/password@ipAddress:portNumber/serviceName
exp username/password@ipAddress:portNumber/serviceName tables=tb1,tb2,tb3
imp username/password full=y file=namafile.dmp


http://www.orafaq.com/wiki/Import_Export_FAQ