title: How to import an Oracle database from dmp file and log file?
body: <p>How would I go about creating a database from a dump file? I do not have an existing database with the same structure on my system so it has to be complete with jobs, events, tables, and so on.</p>
  <p>I placed the dump and log file in E: drive</p>
  <p>I have tried the import utility</p>
  <pre><code>E:/&gt;impdp system/tiger@oratest FILE=WB_PROD_FULL_20MAY11.dmp
  </code></pre>
  <p>But I'm getting error as</p>
  <pre><code>invalid argument value
  bad dump file specification
  unable to open dump file &quot;E:\app\admin\oratest\dpdump\WB_PROD_F
  ULL_20MAY11.dmp&quot; for read
  unable to open file
  unable to open file
  (OS 2) The system cannot find the file specified.
  </code></pre>
  <p>And when I see in Windows Explorer DMP file(taken from Linux server) is showing as Crash dump file</p>
  <p>I don't understand how I can resolve this issue. Please help me to solve this issue.</p>
  <p>I'm a complete newbie on Oracle...</p>