Useful Traditional IMP Commands

Here you can find some useful Import/IMP commands:

1) Command to imp full database:

[chow@hyddb exp_bkp]$ imp system/manager file=full.dmp log=full_imp.log full=y 

2) Command to imp all scotts objects into scott user

[chow@hyddb exp_bkp]$ imp system/manager file=scott.dmp log=scott_imp.log fromuser=scott touser=scott 

3) Command to imp scotts emp table:

[chow@hyddb exp_bkp]$ imp system/manager file=emp.dmp log=emp_imp.log fromuser=scott touser=scott tables=emp 

4) Command to imp scotts multiple tables

[chow@hyddb exp_bkp]$ imp system/manager file=full.dmp log=full_scott_imp.log fromuser=scott touser=scott tables=(emp,dept,salgrade) 

Thats it. Hope this article will help you :)

Regards,
Chowdari