Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Parallel processing, merge Statement

Parallel processing, merge Statement

From: Rick Wiker <rwiker_at_ford.com>
Date: 1 Nov 2004 09:27:27 -0800
Message-ID: <c0821b7a.0411010927.572fc3ee@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US