title: Import one schema into another new schema - Oracle
body: <p>I have a data dmp file exported from one schema user1 using the <code>exp</code> commandline utility.</p>
  
  <p>I want to import this dump onto another newly created (empty) schema user 2 using the <code>imp</code>  commandline utility.</p>
  
  <p>I tried a few things like:</p>
  
  <pre><code>imp system/password@tesdb fromuser=user1 touser=user2 file=E:\Data\user1.dmp log=E:\Data\user1.log
  </code></pre>
  
  <p>I get an error </p>
  
  <pre><code>IMP-00002: failed to open user1.dmp for read
  Import file: EXPDAT.DMP &gt;
  </code></pre>
  
  <p>Any help appreciated.</p>