Re: snapshots of remote views

Thomas Orth (orth_at_delphi.com) wrote:
: 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
: orth_at_delphi.com

I don't believe you can fast refresh the base tables either under 7.0.16 (need 7.1 or greater). Since you can't upgrade, you may need to do full refreshes.

You could temporarily set up a second instance on your machine to test your various options...

Joe

-- 
                                   
=------------------------------------------------------------------=
Joe Nardone <joe_at_access.digex.net> 
"Now that I have my coffee, I'm ready to watch radar."

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6.2

mQBtAzCg5QoAAAEDANvEmc4OAT8wntnCv8UPjyD2kohKVGa1CU21PLpYljzl3AE7
pldpNNscKSoE//aVMKYBO+tRFTTsPNi0qZ6CDlEBXTgJAiszoHh1qCzZyYj7FTBL
YoUr+3sk9rU8Pma6AQAFEbQiSm9lIE5hcmRvbmUgPGpvZUBhY2Nlc3MuZGlnZXgu
bmV0Pg==
=1ocE
-----END PGP PUBLIC KEY BLOCK-----