 | |
#1
 
| |||
| |||
|
terminating SQL execution -
11-27-2003
, 04:36 AM
#2
| |||
| |||
|
|
This is one of my older post which went unanswered. As I also didn't get the answer for this problem, I am posting it again here: --------------- There are so many SQL commands running in the SQL prompt. I want to terminate from the execution. How can I do that(pressing Cirl-C, Ctrl-D doesn't help) ? DB that I use is Oracle: The OS that I work with is Solaris. --------------- |
the terminal settings have Ctrl+C set-up to interrupt (see output from
'stty -a' at shell) ....?
Mark.
#3
| |||
| |||
|
|
qazmlp1209 (AT) rediffmail (DOT) com (qazmlp) wrote in message news:<db9bbf31.0311270236.51edd11f (AT) posting (DOT) google.com>... This is one of my older post which went unanswered. As I also didn't get the answer for this problem, I am posting it again here: --------------- There are so many SQL commands running in the SQL prompt. I want to terminate from the execution. How can I do that(pressing Cirl-C, Ctrl-D doesn't help) ? DB that I use is Oracle: The OS that I work with is Solaris. --------------- I'm sure Ctrl+C works for me (can't test it right now). Are you sure the terminal settings have Ctrl+C set-up to interrupt (see output from 'stty -a' at shell) ....? Mark. |
#4
| |||
| |||
|
|
This is one of my older post which went unanswered. As I also didn't get the answer for this problem, I am posting it again here: --------------- There are so many SQL commands running in the SQL prompt. I want to terminate from the execution. How can I do that(pressing Cirl-C, Ctrl-D doesn't help) ? DB that I use is Oracle: The OS that I work with is Solaris. --------------- |
the integrity of a database. You can interrupt streaming output from a
query, but this can be accomplished by simply closing the output window. As
far as pure SQL statements against the database, I would think that there is
no way to interrupt them except by bringing the database down.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
#5
| |||
| |||
|
|
"qazmlp" <qazmlp1209 (AT) rediffmail (DOT) com> wrote in message news:db9bbf31.0311270236.51edd11f (AT) posting (DOT) google.com... This is one of my older post which went unanswered. As I also didn't get the answer for this problem, I am posting it again here: --------------- There are so many SQL commands running in the SQL prompt. I want to terminate from the execution. How can I do that(pressing Cirl-C, Ctrl-D doesn't help) ? DB that I use is Oracle: The OS that I work with is Solaris. --------------- Being able to interrupt an SQL command would be a signficant way to violate the integrity of a database. You can interrupt streaming output from a query, but this can be accomplished by simply closing the output window. As far as pure SQL statements against the database, I would think that there is no way to interrupt them except by bringing the database down. -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- |
#6
| |||
| |||
|
|
No, there is an alter session kill command. The session that was killed would be rolled back. Or if the session loss a database connection then it would also be rolled back. Jim "John Smith" <jsmith4d4455ij44 (AT) yahoo (DOT) com> wrote in message news:3feb3c87_1 (AT) corp (DOT) newsgroups.com... "qazmlp" <qazmlp1209 (AT) rediffmail (DOT) com> wrote in message news:db9bbf31.0311270236.51edd11f (AT) posting (DOT) google.com... This is one of my older post which went unanswered. As I also didn't get the answer for this problem, I am posting it again here: --------------- There are so many SQL commands running in the SQL prompt. I want to terminate from the execution. How can I do that(pressing Cirl-C, Ctrl-D doesn't help) ? DB that I use is Oracle: The OS that I work with is Solaris. --------------- Being able to interrupt an SQL command would be a signficant way to violate the integrity of a database. You can interrupt streaming output from a query, but this can be accomplished by simply closing the output window. As far as pure SQL statements against the database, I would think that there is no way to interrupt them except by bringing the database down. -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- |
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.