Re: Copying data

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