Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!arclight.uoregon.edu!enews.sgi.com!iafrica.com!nnrp01.ops.uunet.co.za!nnrp01.ops.uunet.co.za!not-for-mail
From: "James" <james@nothing.com>
Newsgroups: comp.databases.oracle.server
Subject: SQL Statement Shutdown
Date: Mon, 3 Mar 2003 11:26:51 +0200
Organization: Ye 'Ol Disorganized NNTPCache groupie
Lines: 14
Message-ID: <1046683618.662160@ftp.adept.co.za>
X-Trace: nnrp01.ops.uunet.co.za 1046683618 9231 196.44.32.35 (3 Mar 2003 09:26:58 GMT)
X-Complaints-To: abuse@uunet.co.za
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Cache-Post-Path: ftp.adept.co.za!unknown@196.44.34.89
X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/)
Xref: newsfeed1.easynews.com comp.databases.oracle.server:178228
X-Received-Date: Mon, 03 Mar 2003 02:26:58 MST (news.easynews.com)

Hi there
I've also posted this question on comp.databases.oracle.server!
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