Re: SQL*Updater ??
- From: Jonathan Knight <knightjck_work@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 17 Feb 2006 10:16:10 -0800 (PST)
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@xxxxxxxxxxxx> 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@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.
> >
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
