title: Oracle data pump import into existing table
body: <p>i need an efficient way to copy data from one database to another.
  Both are based on Oracle 11g.</p>
  
  <ol>
  <li>Step: (Re)create new tables</li>
  <li>Step: Install pl sql packages</li>
  <li>Step: export tables tab_old1 and tab_old2 from database 1 with expdp</li>
  <li>Step: import into tab_new1 and tab_new2 database 2 with impdp</li>
  <li>+x Step: Use installed pl sql procedures </li>
  </ol>
  
  <p>Challenges:
  The pl sql procedures uses already tab_new1 and tab_new2. Thus, I create both tables in step 1 and 2. 
  In step 3 and 4 I import and export only data.
  But tab_new1 and tab_new2 have additional columns -> import fails. 
  I tried to create views without the new columns. </p>
  
  <p>Import fails with the following error message:</p>
  
  <pre><code>ORA-31693: Table data object "Schema"."tab_old1" failed to load/unload and is being skipped due to error:
  ORA-31603: object “tab_old1” of type TABLE not found in schema “Schema” 
  
  ORA-31693: Table data object "Schema"."tab_old2" failed to load/unload and is being skipped due to error:
  ORA-31603: object “tab_old2” of type TABLE not found in schema “Schema” 
  </code></pre>
  
  <p>The views are called tab_old1 and tab_old2, but of course they are not of type TABLE.</p>
  
  <p>Any ideas?</p>
  
  <p>How can I import my data from tab_old1 in an existing table with additional columns?</p>
  
  <p>I don't want to export / import the tables in the first step, rename them, and install pl sqls procedures afterwards. </p>
  
  <p>Could you help me?</p>
  
  <p><strong>edit:</strong></p>
  
  <p>Thanks for your answer. I tried your example twice, but the remap_table function does not work for me. Import: Release 11.1.0.6.0 - 64bit Production.</p>
  
  <p><strong>edit 2:</strong>
  Yes. It seems to be a problem of my oracle version. The remap_table function is ignored. I can write bullshit like remap_table=not.existing/table and impdp doesn't give a shit about it.
  Well, I don't have the time to solve this problem. I must work aroud. Thanks for your help, anyways. </p>