Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to copy a table from a server to another?
ramon_at_conexus.net (Ramon F Herrera) wrote in
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
>
CREATE TABLE FOOBAR AS SELECT * FROM OLD_TABLE_at_OTHERDB; -- presumes a network connect between the two database systems. Received on Wed Nov 17 2004 - 20:40:42 CST