Re: how to handle updates to millions of rows

"Peter Mueller" <lord.of.board_at_gmx.de> wrote in message news:e3b18ff5.0408270202.7de499a5_at_posting.google.com...
> Unfortunately the merge command is not what I was looking for.
> I just need to find an efficient way to join data from two tables and
> have the original records deleted.
>
> before:
>
> table a (apx. 8.000.000 records)
> table b (apx. 8.000.000 records)
> table a_an_b_joined (0 records)
>
> What I would like to have afterwards:
>
> table a (apx. 1.000.000 records)
> table b (apx. 1.000.000 records)
> table a_an_b_joined (apx. 7.000.000 records + converted currencies)
>
> The procedure has to be run once a month.
> How can I achieve this?
>
> Best regards,
> Peter
>
> DB = ORACLE 9i
>
>

Peter

If you can't go to UNDO or adjust rollback have you considered

Loop
Open cursor
Deal with 10,000 rows (insert, delete, delete) Commit
Close cursor
End Loop

Regards

eric

--
Remove the dross to contact me directly