title: Migrating Oracle Database with expdp and impdp
body: <p>Does the target database need to be prepared with tablespace and/or user (schema) in order to successfully migrate a schema from one database (11g R1) to another (11g R2)?</p>
  
  <p>Currently I only can make tests with the 11g R1 database. My test was to export a schema and import it into a new schema within the same database.</p>
  
  <pre><code>expdp system/systempass schemas=oldschema
  </code></pre>
  
  <p>After that I tried to import it with:</p>
  
  <pre><code>impdp system/systempass expdat.dmp remap_schema=oldschema:newschema
  </code></pre>
  
  <p>But this leads to the error:</p>
  
  <pre><code>UDI-00014: invalid value for parameter, 'attach'
  </code></pre>
  
  <ol>
  <li>Does this error tell me that <code>newschema</code> is not defined?</li>
  <li>Do I have to create a new user?</li>
  <li>Do I have to create a tablespace for such a new user?</li>
  </ol>
  
  <p>The questions also relate to a new installed 11g R2 database on a new PC. Any suggestions migrating a database to a fresh installed database are welcome!</p>