Copying data

From: Stefan Landgraf <stefan_at_living-source.com>
Date: Thu, 19 Apr 2001 12:34:46 +0200
Message-ID: <9bmf1j$200h$1@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 - 05:34:46 CDT