[Oracle] 오라클 원격 dump Export, Import

 

---

 

exp, imp 명령어가 가능한 환경(Oracle이 설치되어있다던지)에서

- Export 시

exp ID/PWD@IP:PORT file=FILENAME.dmp

Example)

IP : 192.168.0.99
port : 1521
sid : ORA11

> exp userid/userpwd@192.168.0.99/ORA11 file=abcd.dmp

 

 

- Import 시

imp ID/PWD@IP:PORT file=FILENAME.dmp

Example)

> imp userid/userpwd@192.168.0.99/ORA11 file=abcd.dmp full=y

 

 

---

출처: http://psage.tistory.com/entry/TNS-등록-없이-Oracle-원격-DB-Export-Import[IT etc...]