2 Replies Latest reply: Dec 16, 2012 9:23 AM by Srini Chavali-Oracle RSS

    How to import dmp file into oracle 11g

    979136
      Hi,

      I am new to oracle ,and just have started using it. I installed an Oracle xe. I want to use Impdp command to import dmp file into oracle. I have not used expdp command as I have only dmp file which I need to import. But I know the file was exported using expdp. I am using windows 7 64 bit. When I run impdp ,I get the below error
      ORA-39001 Invalid argument value
      ORA-39000  bad dmp file specficaton
      ORA-31640 unable to open dmp file "C:\oraclexe\app\oracle\admin\XE\dpdump" for read(but my dmp file is located at DMPDATA directory ).
      ....
      Can anyone help me why I am getting this error? . I do not know many things about oracle. May be I am missing some basic steps and keep getting the errors. I would be grateful if I may be referred to tutorials or to the guide where I may have step by step instructions.

      Edited by: 976133 on Dec 16, 2012 3:30 AM

      Edited by: 976133 on Dec 16, 2012 3:30 AM

      Edited by: 976133 on Dec 16, 2012 3:31 AM