Re: Starup trigger doesn't work

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 26 Sep 2008 22:32:11 -0700
Message-ID: <1222493527.471989@bubbleator.drizzle.com>


astalavista wrote:
> Hi,
>
> I created a startup on database trigger
>
> to activate the outline at startup but it doesn't work
>
> do you know why ? (Oracle 9.2.0.4 on windows)
>
> Thanks in advance
>
>
>
> CREATE OR REPLACE TRIGGER valid_outlines_default
>
> after startup on database
>
> begin
>
> execute immediate 'alter system set use_stored_outlines=DEFAULT;';
>
> end;

After taking all of the good advice you have received already it may still not work.

If that is the case run this statement:
SELECT x.ksppinm NAME, y.ksppstvl VALUE, ksppdesc DESCRIPTION FROM x$ksppi x, x$ksppcv y
WHERE x.inst_id = userenv('Instance')

AND y.inst_id = userenv('Instance')
AND x.indx = y.indx
AND x.ksppinm = '_system_trig_enabled';

Then to enabled in your version then:
ALTER SYSTEM SET "_system_trig_enabled" = TRUE SCOPE=BOTH;

Give serious consideration to patching to 9.2.0.8 as well.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Sep 27 2008 - 00:32:11 CDT

Original text of this message