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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 02 Jun 2007 20:56:18 +0200
Message-ID: <f3segg$nb1$1@news3.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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

In that case, I fail to see why earlier attempts did not finish in a reasonable time frame.

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGYb1SLw8L4IAs830RAozuAKCSsl1QXQ3xYmaP6SGJbiUvnBgn+QCggnYF dzwXc7qmxtuSMcg0kpJ5Pjg=
=eRBF
-----END PGP SIGNATURE----- Received on Sat Jun 02 2007 - 13:56:18 CDT