query AUDIT tables and index
How do I query just the audit table and index.
AUD$
I_AUD1
I have tried this
and s.segment_name like '%AUD%'
bit I get anything with AUDIT, E_, S_, W_, and EIM_ in the name. THis is a Siebel database with lots of audit objects. Objects with AUDIT or AUD in the name.
I just want the above table and index. How would I do that with a LIKE operator?
thanks.
AUD$
I_AUD1
I have tried this
and s.segment_name like '%AUD%'
bit I get anything with AUDIT, E_, S_, W_, and EIM_ in the name. THis is a Siebel database with lots of audit objects. Objects with AUDIT or AUD in the name.
I just want the above table and index. How would I do that with a LIKE operator?
thanks.
0