Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to copy a table from a server to another?

Re: How to copy a table from a server to another?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 18 Nov 2004 07:24:04 -0800
Message-ID: <2687bb95.0411180724.36b9f136@posting.google.com>


"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote in message news:<Xns95A4BE01D11ACSunnySD_at_68.6.19.6>...
> 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.

If you need the data in a file for audit, recovery, or some other procedural purposes then you can also run sqlldr and exp/imp via OraNet.

HTH -- Mark D Powell -- Received on Thu Nov 18 2004 - 09:24:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US