sys.aud$

I have archived some data from this table into a table of my own called mdbaudarch.

I want to use dba_audit_trail view to combine information from aud$ and my table.

I have seen following example (slightly modified) in Arup Nanda's book:

# create a combined view
#set -xv

sqlplus /nolog << !
set buffer edit;
conn / as sysdba;
create view aud\$_combined
as
select * from aud$
union all
select * from mdbaudarch.t_mdbaudarch
;

create public synonym aud\$ for sys.aud\$_combined; !

When I do select * from aud$, I do see combined results, but when I do select * from dba_audit_trail I only see rows from sys.aud$, why.

What changes should I make so views such as dab_audit_session, dba_audit_trail etc see both tables.

Prem Received on Sun Feb 06 2005 - 21:16:31 CST