I'm doing that (pinning packages) with a an after
startup trigger owned by the db administration
account.
- Chuck Hamilton <chuck_hamilton_at_yahoo.com> 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_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
Received on Tue Aug 01 2000 - 03:24:17 CDT
