How to backup, clear and migrate Audit data?
Hello ,
Backup:
Please perform the following action plan:
Get full backup of your database before going further in the following action plan.
1. Get the old tables of the previous auditing:
select owner, object_type, object_name from dba_objects where object_name like '%_A';
WHERE EXIST in the AUDITED tables.
For all audit tables that will get back from this query, you will take backup of, like create table xyz_A_bkp as select * from xyz_A
Clear:
2. Go to all auditing groups and Disable this group using the option : Disable - Purge Table and then run the concurrent request "AuditTrail Update Tables"