Hi

I have a table of 10 million rows and I want to delete about 3 millions If
I want to delete every 1000 rows and commit then start over unitll all.

Any hint how to do this.

This is my sql.

delete STATEMENT_LiNE
WHERE rownum < 1000 and stmt_seq in
(select stmt_seq from STATEMENT_HEADER
where to_date(stmt_date,'DD-MON-YYYY') <=
to_date('01-JAN-2000','DD-MON-YYYY')) ;


Thanks in advance

Mitchell


Oracle LazyDBA home page