snapshots of remote views
Date: 1995/12/09
Message-ID: <xBHmkZN.orth_at_delphi.com>#1/1
I am attempting to create an interface with another vendors proprietary
database. We have agreed to set up a distributed database. However,
each database must be able to run independently of the other in case
of a network failure. Also note that our database is 7.0.16, and we
cannot upgrade this until our third party 4gl becomes compatible with
later versions of Oracle. Well, they want to develop applications on
simplified tables that contain information from our normalized relational
model. So, I proposed making views of our tables that look like what
they need, and then they could take a snapshot of the view to have a
local copy. I found out that you can't do a fast refresh of a snapshot of
a view. Is this true? If this is true, then perhaps I can have them
take snapshots of the actual tables and then define views based on the
snapshots so that they can run their existing applications. This raises
a number of questions. Since I can't really test this on my own development
system, does anyone have any experience/suggestions? Much appreciated.
Tom Orth