7 Replies Latest reply on Jan 14, 2013 1:19 PM by Richard Harrison .

    Data Archiving  - Datapump ?


      In order to reduce the volume of data in our main Transactional tables, we are planning to create a new Archive table and move data to the Archive tables.

      I will run this job once in six months to pull old data from my Transaction table into my Archive table -
      Essentially the three steps
      - Find/Select data in transactional table using the Transaction_Date column
      - Insert the selected data into Archive table
      - Delete the selected data from Transactional table

      I was thinking of writing a PL/SQL block, but came across Oracles Datapump and was wondering if Datapump would be a better approach - especially where you need to load in to a target and also delete from the source.

      If you have other ideas, feel free to suggest them too.