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