Re: Shutting down Oracle overnight...

Easy.

  sqldba command="shutdown immediate"

That is OS portable. If under UNIX you can use a trick:

  sqldba <<.EOF
  shutdown immediate
  exit
  .EOF -Andy

sd345_at_city.ac.uk (Michael Collier) writes:
>So what I would like to do is a shutdown immediate each night.
>I have tried (in the dump script)...
> sqldba shutdown immediate
> sqldba "shutdown immediate"
> sqldba 'shutdown immediate'
>...none of which do the trick. All that it ever seems to want to do is
>a plain old sqldba shutdown.
>Can anyone shed any light on this?
>Michael.

-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy_at_vistachrome.com, andy_at_genie.geis.com.
"[The author] neither accidentally nor intentionally omits or includes 
anything that could support a preconceived thesis." - C&EN 21-DEC-92 p.72