title: Does anyone have a sample data migration script (Oracle 10g to Oracle 10g, but different schemas)?
body: <p>I am trying to write a data migration pl/sql script to transfer some of the data in one schema to a different schema on another server.  The second database started as a subset of the original database, but we have modified the schema. So I can't just use the following for each table:</p>
  
  <pre><code>Insert into DB2.table_name select * from DB1.table_name2; 
  </code></pre>
  
  <p>I have tried doing a search for sample scripts that show how to do this, but couldn't find anything.</p>