Re: Bypassing a startup trigger

BD wrote:
> Is there any way to bypass a database startup trigger?
>
> What if someone inadvertently codes something in a startup trigger
> which causes problems? Like (silly example, but just to make the point)
> invokes an infinite loop or grabs absurd amounts of server resources?

edit init.ora and put in the following:
_SYSTEM_TRIG_ENABLED=FALSE conn / as sysdba

recompile the spfile
CREATE spfile FROM pfile='your_init_dot_ora';

startup

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)