Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeeds.sol.net!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: DA Morgan <damorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: SQL Statement Shutdown
Date: Mon, 03 Mar 2003 08:33:35 -0800
Organization: EXE
Message-ID: <3E6383DE.9C338F7F@exesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
References: <1046683618.662160@ftp.adept.co.za>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@splish28.drizzle.com
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: abuse@supernews.com
Lines: 20
Xref: newsfeed1.easynews.com comp.databases.oracle.server:178271
X-Received-Date: Mon, 03 Mar 2003 09:34:06 MST (news.easynews.com)

James wrote:

> 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

This sounds like a very bad idea ... starting with the word ABORT.

Are you sure you really want to do this? And, if so, why?

Daniel Morgan