Re: Loading Data

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 28 Nov 2000 15:39:05 GMT
Message-ID: <3A23D199.2926D79B@edcmail.cr.usgs.gov>

> So long as the tables you speak of are in another Oracle instance you
> can use replication to get the data from one server to another. Check
> out Snapshots and Replication in the Oracle docs. Note that your
> databases will have to be of compatible versions in order for
> replication to work.

Or you could make life a lot easier and just use database links from one database to the other. Replication is an additional cost and Snapshots (or Materialized Views) are only available on Enterprise Edition if memory serves me right.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Tue Nov 28 2000 - 09:39:05 CST