Re: ON COMMIT FAST MViews seems to be less than bulletproof

In short - It can by anything that stops MV from being refreshed properly. Constraints (check, unique, reference) is just a one example.

Another (common) example - you're trying to fast refresh the MV but refresh path is not supported for current mv definition/last dml.

HTH. On 6/19/07, Jared Still <jkstill_at_gmail.com> wrote:
>
> As Alexander Fatkulin has pointed out, putting a constraint on the MV can
> break the refresh.
>

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l