title: oracle - how to copy partitioned table to a new schema on new tablespace
body: <p>I created a datapump export (Oracle 11g) from <code>SCHEMA A</code> on a partitioned table (tablespace <code>TEST``) using</code>TABLE=MYPARTTBL:MYPART`.</p>
  
  <p>I created a new schema <code>SCHEMA B</code> and imported the dump of SCHEMA A's partitioned table with success, but it created the table using the same tablespace <code>TEST</code>. </p>
  
  <p>What I need to do is import the partitioned table to a different tablespace <code>TEST_NEW</code>.</p>
  
  <p>What's a good way to do this? Considering now, that I have a copy of SCHEMA A's partitioned table in SCHEMA B.</p>
  
  <p>Here's my export parfile parameters:</p>
  
  <pre><code>DIRECTORY=DW_PUMP
  TABLES=MRA.FACT_USE:P_20111009
  DUMPFILE=MRA.TBLPART-20111209.dmp
  LOGFILE=MRA.TBLPART-20111209.log
  </code></pre>