Message-Id: <10576.113455@fatcity.com> From: =?iso-8859-1?q?paquette=20stephane?= Date: Tue, 1 Aug 2000 01:24:17 -0700 (PDT) Subject: Re: database open trigger I'm doing that (pinning packages) with a an after startup trigger owned by the db administration account. --- Chuck Hamilton a écrit : > > 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. ===== Stephane Paquette DBA Oracle stephane_paquette@yahoo.com spaquette@houra.fr (33) 01 53 93 06 50 __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites.