This content has been marked as final. Show 2 replies
Have a look at MOS
Bug 5217296 - ORA-32411 reported on materialized view refresh [ID 5217296.8]
This is a restriction in 10.2 (and above), there is a workaround mentioned; however I wouldn't go for it. As this limit doesn't apply to views why don't you create a view upon your whole select statement and then in your materialized view simply do a
select a,b,c,d from your_view
i also thought about create view ... but i just wanted to confirm there are any other way to fix this error.