Re: SQL*Updater ??

From: Jonathan Knight <knightjck_work_at_yahoo.com>
Date: Fri, 17 Feb 2006 10:16:10 -0800 (PST)
Message-ID: <20060217181610.81052.qmail@web60623.mail.yahoo.com>

I just have some test files about 1GB in size and I don't yet know the total number of records I'll be receiving. The process will insert and update and existing table.

The External + merge looks promising. Thanks!

Jon Knight

• Stephane Faroult <sfaroult_at_roughsea.com> wrote:

> ... To be more precise external table + MERGE.
>
> Stéphane Faroult
>
> 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_at_yahoo.com
> > <mailto:knightjck_work_at_yahoo.com>> 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.
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 17 2006 - 12:16:10 CST