Audit Views with _AV# (#>100) Are Not Dropped by Audit Trail Update Table (Doc ID 2341249.1)

Last updated on JULY 30, 2021

Applies to:

Symptoms

The "Audit Trail Update Table" concurrent program will not drop the audit views with _AV# (#>100) for audittrail group with status Disable-purge table.

Changes

The issue can be reproduced at will with the following steps. AR table has been provided just an example, these steps can be performed on any table with 100+ columns to audit.

1. Set audittrail on AR table:
1.1. Set the audit trail group status of <TABLE OWNER>.AR_SYSTEM_PARAMETERS_ALL to Enabled - requested.
1.2. Run the program "AuditTrail Update Tables"
1.3. Confirm AR_SYSTEM_PARAMETERS_ALL_AV# (# is from 1 to 129) have been created.
      SQL> select object_name from dba_objects where object_name like 'AR_SYSTEM_PARAMETERS_ALL_AV%';

2. Perform the audit trail status change in order to drop all audit trail related objects:
2.1. Do a status change. Set the group status of <TABLE OWNER>.AR_SYSTEM_PARAMETERS_ALL to Disable-purge table
2.2. Run program "AuditTrail Update Tables"
2.3. Confirm the views AR_SYSTEM_PARAMETERS_ALL_AV# have remained for # > 100.
      SQL>select object_name from dba_objects where object_name like 'AR_SYSTEM_PARAMETERS_ALL_AV%';

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.