select from remote to update/replace local database

From: Peter J. Schoenster <webmaster_at_rede.com>
Date: Tue, 8 Aug 2000 09:56:33 -0600
Message-Id: <10583.114088@fatcity.com>

Hi,

An oracle newbie. Some of my data will come from a remote database. I will be given access to the remote database once a day (at night). Quick solution is to write a perl script to connect to the remote database,do the select, save to a local file, check that file, then insert that file via sqlldr (could be more than one file but it's the same thing). Another solution would be for a script to run on the remote database that saves its output locally and then ftp's the output to my server. I mention this other option because connecting to the remote database must be via a VPN and my server does not have the VPN software on it :) ..

But I read of this thing called a snapshot (materialized view in Oracle 8 apparently). I'm understanding that I could do something like this:

insert into table (names)values(values) where (select data from remote database)

as a snapshot and have it scheduled to run on a daily basis.

I'm sure you've all been here before.

Peter

---

"Reality is that which, when you stop believing in it, doesn't go away".

• Philip K. Dick

Received on Tue Aug 08 2000 - 10:56:33 CDT