Re: Copying data

From: Andrew Simkovsky <asimkovsky_at_email.msn.com>
Date: Fri, 20 Apr 2001 00:10:31 -0400
Message-ID: <epM476UyAHA.301@cpmsnbbsa09>

Look into the COPY command is SQL*Plus. It has an APPEND option. Just type COPY at the SQL*Plus prompt, and it will give you the syntax.

Andrew Simkovsky
OCP DBA "Stefan Landgraf" <stefan_at_living-source.com> wrote in message 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 - 23:10:31 CDT