Go4Expert

Go4Expert (http://www.go4expert.com/)
-   $1 Daily Competition (http://www.go4expert.com/contests/daily-competition/)
-   -   DOS - Oracle | 20 Dec, 2009 (http://www.go4expert.com/contests/dos-oracle-20-dec-2009-t20394/)

pankaj.sea 17Dec2009 17:27

DOS - Oracle | 20 Dec, 2009
 
Which DOS Command Is Used To Import An Oracle Account To Another Custom Account?
:crazy:

shabbir 20Dec2009 19:11

Re: DOS - Oracle | 19 Dec, 2009
 
Approved.

techgeek.in 21Dec2009 07:23

Re: DOS - Oracle | 20 Dec, 2009
 
"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 21Dec2009 08:18

Re: DOS - Oracle | 20 Dec, 2009
 
Hi Our New Geek!
Your Ans Is Correct!
Congrats & Welcome To The This Forum... ;)


All times are GMT +5.5. The time now is 04:47.