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

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: Fri, 01 Jun 2007 04:58:55 -0700
Message-ID: <1180699135.991253.245070@g4g2000hsf.googlegroups.com>

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 Received on Fri Jun 01 2007 - 06:58:55 CDT