Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: how od you stop a long running command

Re: how od you stop a long running command

From: Dan <djb0x7736d657_at_scream.org>
Date: 26 Aug 2000 05:51:24 GMT
Message-ID: <slrn8qen62.ach.djb0x7736d657@v2000.scream.org>

LPCTSTR <jobob_at_aol.com> wrote:
> Hello,
>
> Im fairly new to Oracle and SQL plus. How do you stop a long running
> command. Lets say you accidently forgot to put the where clause on a
> select statement using a large table, how can you kill that command
> after it has started ?

You can't! This is Oracle's way of teaching you to type more carefu... oh, okay, all right, you can, I was just joking... I don't know what platform you're working on, but on Solaris, a simple control-C (a.k.a. BREAK) does it for me. I'm not sure if Windows NT recognizes control-C as break, but given that older Microsoft operating systems did, I'd hope that it would, too.

Hope that helps,

-Dan

-- 
Dan Birchall - Palolo Valley, Honolulu HI - http://dan.scream.org
Post your reviews; get paid: http://epinions.scream.org/join.html
Free web-based e-mail: http://www.themail.com/ref.htm?ref=1163079
My address expires - take out the hex stamp if your reply bounces
Received on Sat Aug 26 2000 - 00:51:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US