Data_Audit and Task_Audit backup and restore procedure
Hi everyone,
I am looking to back up the DATA_AUDIT and TASK_AUDIT tables for a specific application and then to purge the application in order to respect the best practice of having less than 500.000 records in those tables. I plan to do that by making a database backup (database export operation).
Afterwards I like to be able to reload DATA_AUDIT and TASK_AUDIT inside a copy of the original application in order to consult the data audit and task audit. The requirement is to maintain the audit data for the last 5 years for checking what happened in case of issues.