title: Oracle -- Import data into a table with a different name?
body: <p>I have a large (multi-GB) data file exported from an Oracle table.  I want to import this data into another Oracle instance, <strong>but I want the table name to be different</strong> from the original table.  Is this possible?  How?</p>
  
  <p>Both importing and exporting systems are Oracle 11g.  The table includes a BLOB column, if this makes any difference.</p>
  
  <p>Thanks!</p>
  
  <p><strong>UPDATES</strong>:</p>
  
  <p>The idea here was to update a table while keeping the downtime on the system that's using it to a minimum.  The solution (based on <a href="https://stackoverflow.com/users/119634/vincent-malgrat">Vincent Malgrat</a>'s answer and <a href="https://stackoverflow.com/users/146325/apc">APC</a>'s update) is:</p>
  
  <ol>
  <li>Assuming our table name is <code>A</code> </li>
  <li>Make a temp schema <code>TEMP_SCHEMA</code></li>
  <li>Import our data into <code>TEMP_SCHEMA.A</code></li>
  <li><code>CREATE REAL_SCHEMA.B AS SELECT * FROM TEMP_SCHEMA.A</code></li>
  <li><del><code>DROP TABLE REAL_SCHEMA.A</code></del> Rename <code>REAL_SCHEMA.A</code> to <code>REAL_SCHEMA.A_OLD</code></li>
  <li>Rename <code>REAL_SCHEMA.B</code> to <code>REAL_SCHEMA.A</code></li>
  <li><code>DROP REAL_SCHEMA.A_OLD</code></li>
  </ol>
  
  <p>This way, the downtime is only during steps 4 and 5, both should be independent of data size.  I'll post an update here if this does not work :-)</p>