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

Home -> Community -> Usenet -> c.d.o.misc -> Re: One query Two Databases

Re: One query Two Databases

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 26 Sep 2002 11:36:22 +0200
Message-ID: <amukgi$55$1@ctb-nnrp2.saix.net>


Daniel Morgan wrote:

Adding a few cents to Daniel's reply.

> You can certainly create a database link between the two databases and do
> what you suggest.

See the CREATE DATABASE LINK command. (just in case you're wondering Trevor ;-)

> INSERT INTO newdb_table
> SELECT *
> FROM olddb_table_at_old_database;

I would rather aim for a CREATE TABLE AS UNRECOVERABLE AS SELECT - it will be faster with larger data volumes.

If the data volumes are substantial (10's of millions of rows), I would rather do an export myself.

DBlinks are fine - but if you're pushing a few GB of data like that, you are IMO looking for trouble (personal experience). Network thruput becomes a problem. Then there's the issues of rollbackspace, doing commits, writing/providing a restart ability, etc.

It much faster to rather do an export (using a pipe and compressing at the same), FTP'ing the compressed file across the network, and then do the import.

--
Billy
Received on Thu Sep 26 2002 - 04:36:22 CDT

Original text of this message

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