title: What is the best way to copy a database schema to a different schema in Oracle
body: <p>I am looking for the most efficient way to copy an Oracle database schema to a new schema on different tablespace.</p>
  
  <p>This is what I have tried:</p>
  
  <ol>
  <li>Export the current instance by <code>expdp</code></li>
  <li>Import the instance by using  <code>impdp</code> with REMAP_SCHEMA and REMAP_TABLESPACE attributes.</li>
  </ol>
  
  <p>Is this the best way to achieve the goal? I am on Oracle 11g.</p>