import .dmp file into oracle

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Nurullah
    New Member
    • Nov 2007
    • 1

    import .dmp file into oracle

    hi
    how can i import .dmp file into oracle 9i.give me details.i'm new in oracle so i need to no where i write solution comand.i find answer but i didn't know how it works
  • Saii
    Recognized Expert New Member
    • Apr 2007
    • 145

    #2
    what exactly do you want to know. You have to import using IMP command at command prompt by connecting to database using username/password. There are certains options available for import. Check the description and see what suits your requirement.

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      Please find the details of the topic here and here.

      Comment

      • san1014
        New Member
        • Jul 2007
        • 37

        #4
        You have to type the following command in command prompt

        C:\Documents and Settings\S>imp usrname/password@hostna me file=C:\xxx.dmp (file location) full=y;

        Sandeep

        Comment

        Working...