Re: What to do if a logon trigger get invalidated ?

On Thu, 31 Oct 2002 19:45:39 +0100, "Anton Buijs" <aammbuijs_at_xs4all.nl> wrote:

>Next works in V8.1.7 (Unix), can't say it for V9.2.
>1. On the server itself do connect internal (in 9.2: sqlplus / as sysdba).
>Disable the trigger.
>2. Set the (Oracle internal so undocumented) init.ora parameter
>_system_trig_enabled = FALSE, stop/start the database and then disable the
>trigger. Restart again with the parameter removed.
>

1. does not work, (see earlier post)
2. saves the database.

Thank you

Hans Erik Busk Received on Sun Nov 03 2002 - 03:47:37 CST