Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Automatic startup/shutdown "triggers"
Hi:
There's no way to do this directly in Oracle. However, you could create "S" and "K" shell scripts that run SQL scripts after startup/before shutdown.
Regards,
--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at
http://www.ipass.net/~davesisk/oont.htm
Like original music? Listen to song samples and buy a CD at
http://www.mp3.com/disparityofcult
Richard Rodgers wrote in message <8E319A10AcaliforniadreamingSD_at_news>...
>On every flavor of Unix that I've seen, you can place scripts into
>directories such as rc2.d & name them starting with "S" or "K" to
>"automagically" get desired tasks done at system boot or shutdown.
>
>I'd like to be able to do the same thing with Oracle. I'd like to
>be able to get some custom PL/SQL executed both when the instance
>is started & when it gets shutdown.
>
>I'm open for ideas (as specific as possible) on how to accomplish this.
>
>--
>WARNING - My point & click device is a loaded 9mm
Received on Sun Aug 29 1999 - 20:22:50 CDT