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
Once you have loaded the data in a database on Site A (DB-A)
and cleaned it (or whatever process), you can pass it to Site B (DB-B)
in a number of fashion...
- If the two servers are "networked", you can use a DB link;
- setup an entry for DB-A in tnsnames.ora on Site B
- create a DB link in DB-B, pointing to a schema in DB-A
Then you can access tables in DB-A as if they were in DB-B
or
- Export the clean data, either by individual table export,
or as a transportable tablespace export,
or any other option you are confortable with.
Then you would need to FTP the binary dump file to Site B,
and import the dump file, probably in some working table, to be merged.
Received on Thu Nov 18 2004 - 07:20:11 CST
