Re: Trick, how to pause an import process on windows

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Mon, 3 Oct 2005 10:49:32 +0530
Message-ID: <a144e5210510022219p41c32c28k323236d70eea3efc@mail.gmail.com>

hold on friends,
Have got something.
> From the left window corner you choose Edit/Mark, mark an area (like
> if you would be copying it), and leave marked (white).
>
> The import process will pause until you end the process, ending the
> copy or pressing the enter key.

this doesnt stop the working /execution of the scriptm, the only thing it does is it holds ur cursor to update u with the process until u press enter. I have tried in this way :

I created on table in one schema,test with only one column and using another dba session I executed the following script : declare a number :=0; begin for i in 1..500000000 loop insert into onk.test values(i+1); commit; end loop; end;
Prior of running this script the value in the table was 0 :

SQL> select count(*) from test;

COUNT(*)

3) executed the above script and without marking the count in the table was

SQL> select count(*) from test;

COUNT(*)

48755
4) select the window where the script was running making it white and checked the count in the table :

SQL> select count(*) from test;

COUNT(*)

68021

and it was continuously increasing however the window where the script was running was selected and the screen was white.

What my observation was by selecting the window, the cursor is hold whereever it is but the keeps on running in the background.

On 10/2/05, Chris Stephens <cstephens16_at_gmail.com> wrote:

> wow....i can't tell you how many times i've been baffled as to why
> hitting enter sometimes got an import or script or something running
> again.
>
>
>
> On 10/1/05, Jared Still <jkstill_at_gmail.com> wrote:
> > Is *that* why my windows upgrade scripts sometimes hang until hitting
> ENTER?
> >
> > I'll be more conscious of clicking on the CMD properties from now on.
> >
> --
> http://www.freelists.org/webpage/oracle-l
>

--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 03 2005 - 00:21:32 CDT