Re: SQL Statement SHUTDOWN

James wrote:
> Hi there
> I want to shutdown using a sql statement. The SQL plus statement is SHUTDOWN
> ABORT
> What is the SQL statement for this?
> I thought it was ALTER SYSTEM SHUTDOWN dispatcher_name but it is not working
> for me.
>
> I'm using Oracle 9 on windows
> Cheers
> James
>
>

Just WHAT do you want to shut? your first statement would bring down the instance the hard way. Your second statement has something to do with the listener in an MTS eenvironment? You can't shut a dispatcher; you _can_ stop a listener: C:> lsnrctl stop [listener_name, default: LISTENER]

-- 
Regards, Frank van Bortel