DOS - Oracle | 20 Dec, 2009

pankaj.sea's Avatar, Join Date: Apr 2009
Pro contributor
Which DOS Command Is Used To Import An Oracle Account To Another Custom Account?
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Approved.
techgeek.in's Avatar, Join Date: Dec 2009
Skilled contributor
"imp" command is used for the purpose in the following way:-
suppose my original acccount is "scott" and password is "12345"
Now, i want to dump the original account into a custom account named "techgeek" and password "123"

so the steps are:-

1)navigate to "run" and type there "exp"
after that a command line interface will open with the following queries:-

username: (write over here:- scott)
password: (write over here:- 12345)

Export file: EXPDAT.DMP > c:\scott.dmp


Now again, goto to the command line interface by typing "cmd" in "run"
Now, here begins the actual command:-

imp userid=techgeek/123 fromuser=scott touser=techgeek file=c:\scott.dmp

I hope i got the correct ans.

(My instincts are different from your instincts, techgeek ...pung..pam pam pam pam..sponsor of technology...:-) )
pankaj.sea's Avatar, Join Date: Apr 2009
Pro contributor
Hi Our New Geek!
Your Ans Is Correct!
Congrats & Welcome To The This Forum...