Re: Oracle/NT auto exec sql on startup

Syntactically correct but not appropriate for the job.

We have the same problem here, where the Unix rc file solution would be ideal, we are
struggling with NT.

One of our guys is going to write a simple service which would be dependant upon the database
start service completing successfully. This service would then execute a batch file from a fixed
location which in turn could call others if they exist. Hey presto, a UNIX type implimentation
regardless of how awkward NT makes it.

Cheers,

Fred J

BVB <bart.van.den.bosch_at_ordab.com> wrote in message news:975582400.549083_at_localhost...
> try :
>
> C:\ORANT\BIN\SQLPLUS SCOTT/TIGER_at_ORCL @SCRIPT.SQL
>
> Warning: The user-password will be visible in the script!
>
>
> Chris Lo <chris.lo_at_corp.sunday.com> wrote in message
> news:3A25CD56.D30CD45_at_corp.sunday.com...
> > Dear all,
> >
> > Being in the Unix camp, so I'm not quite familar as how to autoexec
> > certain sql when
> > Oracle/NT starts up. I know about oradim, but it only starts the server
> > but not customized sql.
> > Can anyone give a pointer how to achieve that?
> >
> > Thanks & Regards,
> > Chris
> >
> >
>
>
Received on Thu Nov 30 2000 - 08:15:51 CST