title: Turn on DDL auditing
body: <p>How to audit DDL statements in oracle 10g and clear audited data before 30days... Thank you.</p>
  
  <p><strong>IN EDITION:</strong></p>
  
  <p><strong>How</strong> 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????</p>