Is there any condition due to which a database trigger may get disabled on
creation (or replace), though the status in dba_objects shows as 'VALID'?

In other words, is it possible for a trigger to get disabled, without doing
so explicitly?

Oracle 8.1.7

rgds
amar
http://amzone.netfirms.com

Oracle LazyDBA home page