Message-Id: <10575.113383@fatcity.com>
From: Chuck Hamilton <chuck_hamilton@yahoo.com>
Date: Mon, 31 Jul 2000 08:59:56 -0700 (PDT)
Subject: database open trigger

--0-846930886-965059196=:5642
Content-Type: text/plain; charset=us-ascii


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.
--0-846930886-965059196=:5642
Content-Type: text/html; charset=us-ascii

<P><FONT face="Comic Sans MS">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.</FONT></P>
<P><FONT face="Comic Sans MS">Thanks in advance.</FONT></P>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<P><FONT face="Comic Sans MS">Chuck Hamilton</FONT></P></BLOCKQUOTE><BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Kick off your party with <a href="http://invites.yahoo.com/">Yahoo! Invites</a>.
--0-846930886-965059196=:5642--