8i has database event triggers for LOGON, LOGOFF, STARTUP, SHUTDOWN,
SERVERERROR. You can check out 8i concepts on technet.
David Sisk wrote in message ...
>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 Thu Sep 02 1999 - 06:32:37 CDT
