Large Table Update/Merge problem

I have a temprary table with 5 million rows (A) which needs to be appended with 90 million row table (B).

60% of the rows of the 5mil rows already exist in the big table

i need to update/merge the table A data with table B Oracle version is 8.1.7

Please advice which method is the fastest. i need to do it <30 mins Received on Wed Aug 18 2004 - 02:03:14 CDT