Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: how od you stop a long running command
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 bouncesReceived on Sat Aug 26 2000 - 00:51:24 CDT