The system only audits actions (insert, update and delete)
made to fields that you want audited.
To specify the fields and actions to be audited:
- Navigate to the Table
- Table Field maintenance page for a table on which you
have enabled auditing.
- For each field you want to audit, specify the actions you
want to audit by turning on the
Audit Delete,
Audit Insert and
Audit Update switches as
appropriate.
Note:
Note. You can also turn on
the audit switches using the Field grid at the bottom of the
Table
maintenance page.
CAUTION:
Audit Program
Caching! The audit program from the table
meta-data is read into a program cache on the application
server whenever the date changes or when the server starts. If
you implement new auditing on a table, your audit trail does
not become effective until this program cache is reloaded. In
other words, new audits on tables where the audit program was
not previously specified do not become effective until the next
day (or the next restart of the application server). However,
if you change the fields to be audited for a table where the
audit program is already in the cache, your changes are
effective immediately.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.