Re: ORACLE 8.1.6 fast refresh materialized views

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 31 Jan 2002 21:41:45 -0000
Message-ID: <3c5a47c4$1_3@mk-nntp-1.news.uk.worldonline.com>

George,

We managed a refresh fast on commit (within the same instance) on 8.1.6, but had to use the rowid (just followed the Oracle documentation and it worked out of the box).
Needed to set a couple of init.ora parameters... E-mail me if you need more details.
HTH
Paul

"george" <george.smith_at_sea.siemens.com> wrote in message news:8c74a514.0201311217.5730fc8_at_posting.google.com...
> Does any one have these working successfully in 8.1.6 - we do it with
> out
> problems in 8.1.7 but we are uanble to get the things to fast refresh
> in 8.1.6
> My DBA's say this may be an 8.1.6 issue so I woiuld like to know if
> this is being done successfully by anyone in 8.1.6
>
> Thanks
>
> George
Received on Thu Jan 31 2002 - 15:41:45 CST