Re: how to monitor the progress of inserts
- From: david wendelken <davewendelken@xxxxxxxxxxxxx>
- To: "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 1 Feb 2005 13:07:10 -0800 (PST)
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
