RE: select from remote to update/replace local database

Hello Peter,

why don't you use a database link to the remote database and select the needed data direct into your local tables?

Stephan

-----Original Message-----
From: Peter J. Schoenster [mailto:webmaster_at_rede.com] Sent: Tuesday, August 08, 2000 6:49 PM
To: Multiple recipients of list ORACLE-L Subject: select from remote to update/replace local database

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. Received on Wed Aug 09 2000 - 02:06:08 CDT