RE:
---------------------------------------------------
AUDIT
Purpose
Use the AUDIT statement to:

Track the occurrence of SQL statements in subsequent user sessions. You can track the occurrence of a specific SQL statement or of all SQL statements authorized by a particular system privilege. Auditing operations on SQL statements apply only to subsequent sessions, not to current sessions.
Track operations on a specific schema object. Auditing operations on schema objects apply to current sessions as well as to subsequent sessions.
---------------------------------------------------


No where in the docs does it state how far into the past the audit trail keeps a record of what happened to the database object being audited.

Does anyone here have an idea?

Thanks.

--
Lyndon Tiu
--
http://www.freelists.org/webpage/oracle-l