[Oracle] Oracle Remote Dump Export, Import

 

---

In an environment where Oracle is installed and the exp and imp commands are available:

For Export: 
Use the command 

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

Example: If the IP is 192.168.0.11, port is 1521, and SID is ORA11, then you would use 

exp userid/userpwd@192.168.0.11:1521/ORA11 file=sample.dmp

 

---

For Import:
Use the command 

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

Example: To import, you would use 

imp userid/userpwd@192.168.0.11:1521/ORA11 file=sample.dmp full=y

 

---