... To be more precise external table + MERGE.
David Sharples wrote:
define large and are they simple inserts or updates?
using external tables and simple sql might be worth looking at
On 2/16/06, *Jonathan Knight* <knightjck_work@xxxxxxxxx <mailto:knightjck_work@xxxxxxxxx>> wrote:
My current project requires a largish daily update to a database table. Is there any way to do this with SQL*Loader? If not, I'm looking at loading to a temporary table and kicking off a PL/SQL job to update the affected records.