Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Remote or Local?
On Sep 20, 6:54 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Oracle 10.2.0.3.0, Windows 2003 Server
>
> Two servers: Let's call server A "Lutsen" and server B "Annapurna".
>
> Scripts are located and executed on Lutsen to read/insert/update and create
> indexes on tables (a few 30+ and 80+ million rows in size) all located on
> Annapurna.
>
> Since the tables being processed reside on Annapurna, shouldn't the code
> that gets run also be located on Annapurna so that all the network traffic
> would be eliminated?
>
> Also, wouldn't having this situation cause extensive, and unnecessary
> network traffic, which could greatly increase the time for the scripts to
> finish?
You can send the data over to the server where the database runs. Use external tables to define the structure then do insert into real_oracle_table select from external_table ... Received on Thu Sep 20 2007 - 18:37:20 CDT