Required Methodology for Moving data from production to Archive Database
798761Dec 15 2011 — edited Dec 16 2011Hi All,
Our production database is Oracle 11g and I have the following scenario.
every day 2 tables in the production database accumulates 2 million records each table has 10-12 columns.
The requirement is that we should be storing only the data for the last 15 days and the rest to a similar archive schema, and the archive database
should maintain records for 5 years i.e (5*365*2,000,000)= 3,650,000,000 3.6 billion records.
Now the main concern is how to move data from the production to the archive database.
Please suggest any good mechanism for moving the data automatically.