Re: sys.aud$

Michel's reply was all you needed.
You should create your own views similar to dba_audit_trail and dba_audit_session.

Lookup the original view definition of the dba view:

set long 10000
select view_text from dba_views where view_name = 'DBA_AUDIT_TRAIL';

You would then create your own views:

create or replace my_audit_trail
as
select .......
from (select * from sys.aud$ union all select * from myschema.myaudittable) aud, .....
/ Received on Tue Feb 08 2005 - 15:04:49 CST