Hi All,
I am new to oracle community and new to data archival. Looking for help !
I have received a requirement to do archival of data from oracle 9i and to store in oracle 12c database ( for the past 5yrs ) .
Also, 10 yrs of data should be archived each year as per retention policy and purge the data which is not in this time frame.
Please do share your inputs on the steps needs to be followed.
I have got the list of tables to be archived.