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
How to completely shutdown in windows 8
However, shutdown user interface at windows 8 was not completely shutdown. At least shutdown but still in hibernate state
I will show you how to shutdown with command prompt, go to command prompt.exe you can access this by user interface program or shortcut with run windows, just press Windows+R and type cmd then enter
Type this
shutdown /s /t 0
* 0 means in second if you set for example 3600 it was 1 hours countdown time to shutdown
Thursday, November 6, 2014
MC Skin Apocalymon no click and skill removed
Apocalymon no click and skill removed download here
Read More
Subscribe to:
Posts
(
Atom
)