Parallel processing, merge Statement

I have a procedure that pulls up to 1 million records per day from an external database through a database link. Currently I insert the records into a staging table and then run a merge statements to update my local tables.

I have been looking at some of the ETL enhancements added to 9i. It appears that it would be more efficient for me to use an external table and pipe the data to the merge process, but I'm really not sure how to go about doing so.

Does anyone have an example of how this would be accomplished?

Thanks for any assistance. Received on Mon Nov 01 2004 - 11:27:27 CST