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

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

Martin T. 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).
>
> The texts we're talking about is some 5000 updates or about 1MB of
> data.
> (Copying this amount over the net does take about one minute.)
> However, we are unable to come up with a solution where we can load
> these into the DB in a finite amount of time. (Running it on the local
> test-db takes a few seconds)
> *) SQL script with 5000 updates ... takes forever. (read: hours)
> *) Grouping the updates into a PL/SQL block ... takes forever.
> *) Working with a intermediate table-dump and exp/imp ... takes
> forever.
> *) Currently trying SQLLoader ...
>
> Are we using the right tool(s)?
> Do I have to tweak some Oracle Connection settings to make it work?
>
> thanks for any tips!
> br,
> Martin
>

Move the data over, have a script check whether the data file has arrived, wait for some time to allow the copy process to complete (better yet: send a 0-byte file as end-of-transmission indicator).
Move file to a working directory and process everything locally (remote - from your end).
Delete or move files to archive when completed. Consider sending logs back, or making logs available via web.

• -- Regards, Frank van Bortel

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

iD8DBQFGXwR2Lw8L4IAs830RAhv4AJ4pVPhK0pMngWlyL97EF0fsz3K4mgCeLjSf DixHyuarOu0ghuTZYZkSWl8=
=tOWZ
-----END PGP SIGNATURE----- Received on Thu May 31 2007 - 12:23:02 CDT