Auditing question

From: R.B <rich.bevan_at_bt.com>
Date: Tue, 9 Dec 2003 11:24:16 +0000 (UTC)
Message-ID: <br4bcv$ref$1@visp.bt.co.uk>

I have started auditing on a 9.2.0.3 database by setting the following in the initSID.ora file

audit_trail = db
audit_file_dest = /u01/app/oracle/admin/SID/adump
audit_sys_operations = true

and then setting the database to audit 'create table'. When a table is created, an entry is made in a file in the 'audit_file_dest'. What I am trying to do is be able to run a query from the db to find the information such as - when 'create table' was run and by who etc. Can this information be acessed from the db or do scripts have to be written to get the information from the Unix files. If I have to get the info from the '.aud' files has Oracle already got a utility to do this ?

Thanks for any help Received on Tue Dec 09 2003 - 05:24:16 CST