Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: One query Two Databases
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.
-- BillyReceived on Thu Sep 26 2002 - 04:36:22 CDT