1. modify parameter
alter system set audit_trail=db_extended scope=spfile;
shutdown immediate;
startup open;
2. start to audit table
create table test(id number, name varchar2(40));
AUDIT INSERT,UPDATE,DELETE,SELECT on test;
3. see the audit configuration
select * from dba_obj_audit_opts;
4. do some DDL and DML
select * from test;
insert into test(id, name) values(1, 'andy');
5. check the result;
select * from dba_audit_trail order by timestamp desc;
6. cancel the audit;
noaudit INSERT,UPDATE,DELETE,SELECT on test;