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

On Jun 2, 8:56 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> -----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.
>

Well, there were no earlier attempts with _SQLLoader_. There were the attempts with x update stmts in a sql scripts and the exp/imp approach which failed utterly. The SQLLoader approach just worked ...

If anyone likes to comment on why loading a table over the network via SQLLoader is 1000x faster than via imp (or SQL) I'd be more than happy ...
As it stands, I now "know" that I'll have to use SQLLoader over slowish connections ...

br,
Martin Received on Sat Jun 02 2007 - 18:13:54 CDT