Re: I need Oracle help. Lotsa questions here. Oracle autostart options? Oracle SQL Cron? Online export?
From: Rudi Demeulenaere <rdm_at_datafront.spamnothanks.be>
Date: Mon, 21 Sep 1998 00:09:28 +0200
Message-ID: <36057D18.4714AB2E_at_datafront.spamnothanks.be>
Date: Mon, 21 Sep 1998 00:09:28 +0200
Message-ID: <36057D18.4714AB2E_at_datafront.spamnothanks.be>
paul_wass_at_my-dejanews.com wrote:
> We're running Oracle 7.3 on a Novell Netware box.
>
> I have a multiple questions here.
>
> 1) Is there any way to automatically have Oracle run a set of 'Stored
> procedures' when the database first starts up?
> (etc)
There are ways,
but why not simply "cronning" the adequate sqlplus scripts ?
Cron entry containing
sqlplus username/password _at_scriptname.sql scriptname.sql containing
execute package.procedure(variable);
quit;
r u d i Received on Mon Sep 21 1998 - 00:09:28 CEST