Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Testing strategy for Archiving & Purging

user5722493Mar 15 2019 — edited Mar 15 2019

Hi,

Our client is  planning to down size the database of their application. Currently there is 20 years of data and in production they want to keep only last 5 years data and rest will be archived.

I am little bit confuse about the testing strategy of this archiving and purging process.

Client is asking, how they will validate this archiving and purging process, so that it will ensure what ever data has been left as an active (last 5 years data), are accurate and there is no loss of data.

Thanks with Regards,

JD

Comments
Post Details
Added on Mar 15 2019
1 comment
559 views