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

On May 31, 7:23 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> 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
> > (...)
> > 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
>

Thanks for this advice. Of course this is always an option, but I really felt there should be a more straightforward solution for "just" one (1) MB of data ... ?

cheers,
Martin Received on Thu May 31 2007 - 13:03:51 CDT