Re: How to get data into Oracle over a mediocre network connection

On Jun 1, 11:01 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jun 1, 4:58 am, "Martin T." <bilbothebagginsb..._at_freenet.de> wrote:
> > On Jun 1, 12:01 am, joel garry <joel-ga..._at_home.com> wrote:
>
> > > On May 31, 8:39 am, "Martin T." <bilbothebagginsb..._at_freenet.de>
> > > wrote:
> > (...)
> > We have now tried out the solution with SQLLoader and it seems that
> > this is indeed the tool for the job. Using SQLLoader we see (nearly)
> > the same performance as with a simple copy over the network.
> > So it will be SQLLoader + PL/SQL script that copies the data from the
> > temporary table to the real target table.
>
>
> What is it that makes you need PL/SQL over plain old SQL?
>
> jg

Hm ... I guess it's that we want to UPDATE the actual table with the data that we put into the temp table. (And PL/SQL is also plain enough for me :-)

cheers,
Martin Received on Fri Jun 01 2007 - 20:41:47 CDT