Data Archiving - Datapump ?
Hi,
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.
Thanks!
Anand