How to disable and remove audit tables in an environment without disabling CFR Pat 11
Hi,
We have CFR Part11 enabled in our Dev (DV) environment. We want to disable table audit for the current tables getting audited and remove them but keeping the environment audit information intact(enabled) so that we can create table audit again in future in the same environment.
The steps I can see is:
- Disable auditing in DV at table level using P9500003
- Dropping audit Views.
- Dropping audit triggers.
- Renaming base tables.
- Dropping CFR11 shadow columns.
Am I missing anything?
Thanks,
Jyotirmoy