Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to handle updates to millions of rows
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
Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:
> In that case: lookup the merge command - it's far more
> efficient than any PL/SQL!
> See:
> http://asktom.oracle.com/pls/ask/f?p=4950:8:2999541794298325973::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6618304976523,
Received on Fri Aug 27 2004 - 05:02:55 CDT