Re: database open trigger

From: Rivaldi Bahar <rivaldi_bahar_at_hotmail.com>
Date: Tue, 01 Aug 2000 01:55:06 JAVT
Message-Id: <10575.113404@fatcity.com>

If lost, simply execute dbmsstdx.sql in $ORACLE_HOME/admin through Svrmgr or sqlplus sys.

Rivaldi

>From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: database open trigger
>Date: Mon, 31 Jul 2000 09:03:46 -0800
>
>
>I'm trying to follow one of oracle's suggestions to eliminate ora-04013
>errors which is to pin the SYS.STANDARD package when the database starts
>up. I figured this would be a good use of the new database startup
>triggers. My question is what's the best way to imlement this. Should the
>trigger be owned by SYS, or some other user but compiled by SYS? If I'm not
>mistaken, isn't the SYS schema skipped during exports. I'd hate to lose the
>trigger if I ever did a full export/import.
>
>Thanks in advance.
>
>Chuck Hamilton
>
>
>
>
>
>---------------------------------
>Do You Yahoo!?
>Kick off your party with Yahoo! Invites.

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Wed Dec 31 1969 - 17:59:59 CST