title: How to audit deletes in a certain table with Oracle?
body: <p>I'm trying to record <code>DELETE</code> statements in a certain table using Oracle's auditing features.  I ran:</p>
  
  <pre><code>SQL&gt; AUDIT DELETE TABLE BY TPMDBO BY ACCESS;
  
  Audit succeeded.
  </code></pre>
  
  <p>I'm unclear if this audits the deletion of a table schema itself (ie, dropping the table), or if it audits the deletion of one or more rows within any table (ie, the delete command).  If the latter, how do I limit this auditing to only a table called <code>Foo</code>?  Thanks!</p>
  
  <p><strong>UPDATE:</strong></p>
  
  <pre><code>SQL&gt; show parameter audit
  
  NAME                                 TYPE        VALUE
  ------------------------------------ ----------- -------------
  audit_file_dest                      string      /backup/audit
  audit_sys_operations                 boolean     TRUE
  audit_syslog_level                   string
  audit_trail                          string      XML, EXTENDED
  </code></pre>