Re: ON COMMIT FAST MViews seems to be less than bulletproof
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: Mark.Brady@xxxxxxxxxxxxxxxxx
- Date: Tue, 19 Jun 2007 09:13:41 -0400
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@xxxxxxxxx> wrote:
As Alexander Fatkulin has pointed out, putting a constraint on the MV can
break the refresh.
--
Alexander Fatkulin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
