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

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).
>
> 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

Do what Frank said, and also see External Tables and Transportable Tablespaces.

jg

--
@home.com is bogus.  "Montezuma forbade women to eat chocolate. The
Spanish Catholic Church forbade consumption of chocolate because it
was thought to lead to licentious behavior. I cannot think of a better
promotional campaign than that to get people to eat chocolate. " -
Arlyn Hackett