Re: how to monitor the progress of inserts
- From: rjamya <rjamya@xxxxxxxxx>
- To: juancarlosreyesp@xxxxxxxxx, Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Feb 2005 07:27:35 -0500
... 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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
//www.freelists.org/webpage/oracle-l
Other related posts:
