Friday, November 28, 2014
How to import and export oracle database dump file with command prompt
Here i will show you how to imp or exp database dump file (.dmp) with command prompt, first you must have a dmp file and a oracle database (LOL)
Import
First step : make sure you already created user schema for import and make sure you grant the user at least have dba, if you didnt know how to grant look this tutorial
Second step : put your dmp file at dpdump folder at ..\product\youroracleversion\admin\servicename\dpdump
Last step : run command prompt as administrator and type this
impdp userschema/userschemapass@servicename -dumpfile=yourdumpfilename.dmp -directory=data_pump_dir
Export
Run command prompt as administrator and type this
expdp userschema/userschemapass@servicename -dumpfile=yourdumpfilename.dmp -directory=data_pump_dir
Database dump file will located at ..\product\youroracleversion\admin\servicename\dpdump
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment