Re: how to monitor the progress of inserts

... EXCEPT that when you use dbms_output, it is visible to you ONLY AFTER the whole process is finished. Which doesn't help the OP at all.

Raj

On Tue, 1 Feb 2005 19:03:31 -0400, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
> I think this solves the problem if the code can be modified, without
> harming performance.
>
> SQL> CREATE or replace PACKAGE TEST
> 2 IS
> 3 nCount NUMBER :=0;
> 4 END;
> 5 /
>
> SQL> create table test2 as select * from dba_objects where 1=0;
> SQL> select count(*) from dba_objects;
>
> COUNT(*)
> ---------
> 29541
>
> SQL> begin
> 2 INSERT INTO test2 select * from dba_objects ;
> 3 test.ncount := test.ncount + sql%rowcount;
> 4 dbms_output.put_line('total inserted:'||test.nCount);
> 5 rollback;
> 6 end;
> 7 /
> total inserted:29541
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
http://www.freelists.org/webpage/oracle-l