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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Copying data

Re: Copying data

From: Klaus Zeuch <KZeuch_at_hotmail.com>
Date: Thu, 19 Apr 2001 20:31:53 +0200
Message-ID: <9bnb3n$cg3$04$1@news.t-online.com>

See "CREATE DATABASE LINK" in the Oracle documentation set:

"The following statement defines a fixed-user database link named sales.hq.acme.com:

CREATE DATABASE LINK sales.hq.acme.com

   CONNECT TO scott IDENTIFIED BY tiger
   USING 'sales';

Once this database link is created, you can query tables in the schema scott on the remote database in this manner:

SELECT *
   FROM emp_at_sales.hq.acme.com;"

hth

Klaus

"Stefan Landgraf" <stefan_at_living-source.com> schrieb im Newsbeitrag news:9bmf1j$200h$1_at_wrath.news.nacamar.de...
> Hi Experts,
>
> Which is the easiest way to copy records from
> one Oracle Server to another?
> Both Ora-Servers (8i) run on different machines in the
> same NT-Network
> I need to do something like
> SELECT bla FROM Server1.DatabaseX.Table1
> and then take these records and perform an
> INSERT INTO Server2.DatabaseX.Table1
> with them.
>
> And I need this to run automatically overnight.
>
> Can anybody help?
>
> Thanks, Stefan Landgraf
>
>
> --
> --
> --
> stefan landgraf living source gmbh tel +761 / 15 258-26
> hanferstr. 28 79108 freiburg i.br. fax +761 / 15 258-50
>
>
>
>
>
>
>
Received on Thu Apr 19 2001 - 13:31:53 CDT

Original text of this message

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