ramon_at_conexus.net (Ramon F Herrera) wrote in message news:<c9bc36ff.0411171818.4041541d_at_posting.google.com>...
> Hello:
>
> We have 2 Oracle servers, one in each city. We currently
> generate data on site A as ASCII text (filename.txt), copy
> it to site B where it it converted to a 'filename.dat' file and
> loaded into Oracle. With the current scenario the Oracle
> server on site A is just iddle doing nothing. We are transfering
> duplicate records, bad data, etc.
>
> What I'd like to do is to load the data with SQL*Loader in the
> first site and then copy the table to the remote site B.
>
> So, instead of performing a copy from a Unix filesystem to
> another I need to copy from Oracle to Oracle.
>
> How do I copy a full table from an Oracle server to another??
>
> TIA,
>
> -Ramon F Herrera
Check out this link: http://www.dbazine.com/moore3.shtml
Received on Thu Nov 18 2004 - 07:09:28 CST
