title: Appending data while doing Exchange partition in Oracle
body: <p>I am trying to build Archival method for my database application. I have few reporting tables which are already partitioned. These reporting tables are huge and are partitioned on monthly basis. I am using Exchange partition method for faster performance. By default the archival job runs every 30 days.</p>
  
  <p>Note: I have specific archival tables for each reporting table.</p>
  
  <p>Problem statement: I need to store archive data for an year in the archival tables. Can I append the data in archival tables using Exchange partitioning method?</p>