Re: how to monitor the progress of inserts

Niall,

Very nice explanatory script. Kudos.

>SQL> insert into t1
> 2 select rn
> 3 from (select rownum rn,'x' from all_objects,all_objects where rownum < 1001
>);

>1000 rows created.

>SQL> rollback;

>Rollback complete.

>SQL> select table_name,inserts,updates,deletes from useR_tab_modifications;

>TABLE_NAME INSERTS UPDATES DELETES

------------------------------ ---------- ---------- ----------


>T1                                   1000          0          0

>precise but wrong and certainly a violation of relational rules.

It's not wrong at all. There were 1000 inserts and it showed you that. It's not complete - in that there were also 1000 rows rolled back - but it's not wrong.

It's not saying that there are 1000 rows in the table, just that 1000 inserts have been made.

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