Snapshots based upon views

From: <bbl_11_at_hotmail.com>
Date: Wed, 17 Apr 2002 17:44:31 GMT
Message-ID: <3cbdb3ef.7336530_at_news.easynews.com>


Hi,

For security reasons I have to create snapshots based upon views in the masterdatabase rather than on tables. I am using Oracle 8i SE 8.1.7. It seems to work, but once I had a message during the first refresh that talked about problems with the primary keys. But when I did the refresch again it seemed to work.

Does anybody know if it is a good idea to create snapshots based upon views in the masterdatabase ? What problems could occur ?

Thanks,

Philippe. Received on Wed Apr 17 2002 - 19:44:31 CEST

Original text of this message