I'm trying to record DELETE statements in a certain table using Oracle's auditing features. I ran:

SQL> AUDIT DELETE TABLE BY TPMDBO BY ACCESS;
Audit succeeded.

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 Foo? Thanks!

Yea these are actually the docs I've been reading the past day. I'm afraid I still don't follow them. I've tried the examples, but they're unclear how they actually map to a real database and what I should expect. I see nothing in the DBA_AUDIT_TRAIL view so something isn't working.
–
Mike ChristensenJan 4 '12 at 19:20

from sqlplus, what do u see if u do: show parameter audit
–
tboneJan 4 '12 at 20:03