Re: Trick, how to pause an import process on windows
From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
To: cstephens16@xxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 3 Oct 2005 10:49:32 +0530
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 :
1) 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;
2) Prior of running this script the value in the table was 0 :
SQL> select count(*) from test;
COUNT(*)
----------
0
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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
