Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL trigger only working on one database
Mark D Powell wrote:
> Eric Kimble <ekimble_at_wfl.fha.dot.gov> wrote in message news:<3DBF0D45.C420A7E3_at_wfl.fha.dot.gov>...
> > Hello, I was trying to implement the ddl trigger exercise located on
> > Jonathan's page written by Norman (thanks for all you folks have done, I
> > really appreciate it) on one instance. It didn't work (no errors so I
> > tried it on another and it worked. I don't get any error just no data.
> > EKIMBLE_at_DOLPHIN>alter table test nologging;
> >
> > Table altered.
> <snip>
>
> Eric, since we know the code is good (as it worked on one instance)
> then I would think that means it is a db specific issue. Check the
> init.ora and registry settings for _SYSTEM_TRIG_ENABLED = FALSE. This
> parameter disables db event triggers and has to be set during upgrades
> from prior releases so it seems a likely possiblility that it is set.
>
> HTH -- Mark D Powell --
Mark,
Thanks, I came to the conclusion as well that it had to be database specific but didn't look throught
the init.ora file closely enough. Sure enough _system_trig_enabled=true. I set that for the last
upgrade I did and forgot to set it back.
Sybrand,
Thanks for the reply, I had tried that but neglected to mention that in the origional post. After
restarting the database it is working properly. Thanks for the help everyone.
Eric
Received on Wed Oct 30 2002 - 09:20:56 CST