Re: DBA_SOURCE vs DBA_TRIGGERS

Michael J. Moore wrote:
>
> For trigger source I understand that the source code can be found in
> DBA_TRIGGERS.
> Also, I thought that the same trigger source could be found in DBA_SOURCE.
> However,
> this does not seem to be always the case. So, the question is .. Under what
> conditions should
> one expect to find ( or not find) trigger source in DBA_SOURCE.
>
> Does source being in either of these tables contengent on a clean compile?
> Mike

Not sure on this one, but at some stage (7.3?) Oracle changed from triggers being uncompiled (ie the compiled p-code was not retained - it was compiled on the fly when it got aged out of the cache) versus the p-code being retained..

Maybe an 'alter trigger ... compile' sticks it on xxx_SOURCE ? (not verified by me)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."