Hi Friends


SCENERIO
------------
I have set the auditing options for my oracle 8i database.
I have added a parameter "Audit_Trail = True" in init.ora.

I have set System, Statement, and Object auditing options in my system.

Auditing Trail Records are stored in SYS.AUD$ table. There are 1047 records in sys.aud$ table.

QUERY
--------
How will I know, which audit trail records belong to System auditing, Object Auditing and Statement Auditing? I am not able to decide how should I delete System, Object, Statement audiitng records separately with 3 delete statement....

It would be great help.

Thanks in advance.

Please let me know if u want any more information on it

Dharmesh
dharmesh.bangali@hsoftcon.com