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 -> Re: How to get data into Oracle over a mediocre network connection

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 02 Jun 2007 08:36:11 -0700
Message-ID: <1180798569.146813@bubbleator.drizzle.com>


Martin T. wrote:
> 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

Enough perhaps but far less efficient which, I believe, was the point of Joel's statement. SQL rather than PL/SQL is a good guideline.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Jun 02 2007 - 10:36:11 CDT

Original text of this message

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