Re: Oracle/NT auto exec sql on startup

"Fred.J" <fred.johnson_at_baesystems.com> wrote in message news:3a266066_at_pull.gecm.com...
>
> 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
> > >
> > >
> >
> >
>
>

If you have Oracle 8i you should use the on-database trigger to accomplish this, and save yourself the trouble of writing a service. If you don't have 8i, you have a reason to upgrade.

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Nov 30 2000 - 09:17:51 CST