Saturday, March 4, 2017

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

No comments:

Post a Comment

Some Most Popular Articles