Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get data into Oracle over a mediocre network connection
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
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.orgReceived on Sat Jun 02 2007 - 10:36:11 CDT
![]() |
![]() |