SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Canceling query in SQL developer

MansiRavalSep 13 2017 — edited Sep 14 2017

Hello Experts,

Needed some help on below topic.

I am using SQL developer Version 4.1.0.19 and database version Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64 bit.

I have fired one query select * from table X where table X has around 1000000 records in it. But I canceled it in between. As far as I know query does not get cancel,it keeps running in background.

but when I try to scroll through the records I got below error.

ORA-01013: user requested cancel of current operation

My question is does canceling query from sql developer actually cancel the fired query?

This post has been answered by unknown-7404 on Sep 13 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2017

Added on Sep 13 2017

#sql-developer

4 comments

4,304 views