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

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:
> > > Greetings!
> > > [Oracle 9i2, Windows XP]
>
> > > We are trying to automate the maintainance of some application texts
> > > for a db-app. The DB is located overseas, so the network connection is
> > > rather slow (compared to LAN/local).
>
> > > *) Currently trying SQLLoader ...
>
> > Do what Frank said, and also see External Tables and Transportable
> > Tablespaces.
>
> > jg
>
> Well. I have not done what Frank said. (I think it's overkill for one
> (1) MB of data).
>
> 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.
>
> Thanks anyway,
> br,
> Martin

What is it that makes you need PL/SQL over plain old SQL?

jg

--
@home.com is bogus.
http://maps.google.com/maps?f=q&hl=en&q=100+twin+dolphin+drive+redwood+city,+ca&sll=37.0625,-95.677068&sspn=45.688268,74.707031&ie=UTF8&om=1&layer=c&cbll=37.528632,-122.264527&cbp=1,360,0.510088687568257,0&ll=37.532105,-122.263992&spn=0.011231,0.018239&z=16