Re: How to update a huge table efficiently

Tansel Ozkan wrote:
>
> I need to update a 10 million record table everymonth. About 95% of the
> records will be updated. I am planning to load the update information to
> another table, then run a PL/SQL procedure to update the records that
> are already in the master table or insert the new records that do not
> exist in the master table. But, probably this will be extremely slow.
> Any suggestions on how I can go about doing this would be appreciated...

You could consider spooling the whole thing out of Oracle to a file, truncate the table, run a C program to write the updated rows to another file and then direct path load them back in.

Or you write Pro*C to select and write the updated file instead of spooling and using C - I don't know which would be faster.

Best regards,

Sten Vesterli
Systems Engineer
TPI - Tom Pedersen International A/S
sev_at_tpi.dk Received on Sun Nov 10 1996 - 00:00:00 CET