How to audit DDL statements in oracle 10g and clear audited data before 30days... Thank you.
IN EDITION:
How can I turn on auditing on "ALTER TABLE" statement? when I run AUDIT TABLE; or AUDIT ALTER TABLE; or AUDIT ALTER ANY TABLE; Audited information can't be seen in AUD$ or DBA_AUDIT_TRAIL views.(Just event when system user alters table is written,but there is no record for HR user) why????