title: Archiving (old) application data in (Oracle) Database
body: <p>I have a fairly large Business Application related to Order Management, whose data is in Oracle Database.</p>
  
  <p>All data can be related to Orders.
  Now, the data size is huge, millions of records in tables - thereby slowing down my application SQL Queries.</p>
  
  <p>I am planning a replica schema of my main 'Order Schema', say 'Archive Order Schema'.
  And write SQL Queries to move (old order) data from main to archival schema, one (old) Order at a time.</p>
  
  <p>But the SQL Queries are quite slow, and to move all data of a (old) Order (across so many tables), takes very long time. </p>
  
  <p>Any design / approach / optimization inputs are welcome.</p>