1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

DOS - Oracle | 20 Dec, 2009

Discussion in '$1 Daily Competition' started by pankaj.sea, Dec 17, 2009.

  1. pankaj.sea

    pankaj.sea New Member

    Joined:
    Apr 6, 2009
    Messages:
    461
    Likes Received:
    13
    Trophy Points:
    0
    Occupation:
    Web Developer
    Location:
    Kolkata
    Home Page:
    Which DOS Command Is Used To Import An Oracle Account To Another Custom Account?
    :crazy:
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,292
    Likes Received:
    365
    Trophy Points:
    83
    Re: DOS - Oracle | 19 Dec, 2009

    Approved.
     
  3. techgeek.in

    techgeek.in New Member

    Joined:
    Dec 20, 2009
    Messages:
    572
    Likes Received:
    17
    Trophy Points:
    0
    Occupation:
    EOC (exploitation of computers)..i m a Terminator.
    Location:
    Not an alien!! for sure
    Home Page:
    "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...:) )
     
  4. pankaj.sea

    pankaj.sea New Member

    Joined:
    Apr 6, 2009
    Messages:
    461
    Likes Received:
    13
    Trophy Points:
    0
    Occupation:
    Web Developer
    Location:
    Kolkata
    Home Page:
    Hi Our New Geek!
    Your Ans Is Correct!
    Congrats & Welcome To The This Forum... ;)
     

Share This Page