5.17.3 Prevent Error
For the most current information, see My Oracle Support article 727208.1, AuditTrail Update Tables fails on View AP_SYSTEM_PARAMETERS_ALL_AC1.
To follow Step 1 in the article, do the following:
-
Log in to Oracle LSH as sysadmin.
-
Navigate to System Administrator, then Security, then Audit Trail, and then Groups.
-
Confirm anything necessary to get the application to run and a form appears.
-
Press F11.
-
In the Audit Group line enter
SQLAP.AP_SYSTEM_PARAMETERS_ALL
and press Ctrl+F11. The Audit Group SQLAP.AP_SYSTEM_PARAMETERS_ALL appears. -
Proceed with Step 2 in the MOS article.
Step 2 in the article is:
- Set the Group state to "Disable - Purge Table" for AP_SYSTEM_PARAMETERS_ALL. This option Disable - Purge Table Drops the auditing triggers and views and deletes all data from the shadow table.
- Be sure to Save before exiting.
Step 3 in the article is Run the Audit Trail Update Tables Concurrent Program.
Parent topic: Start Journaling Internal Tables