C_wancio reminded mi some things with MV.
When you use refresh from wizard, you can select rollback segment.Everything is ok until you are on database with Automatic Undo Managment. If you chose other than default , and click refresh error is raised. I think this option should be locked for database using this mode. ( default in 9i and 10G).
When you have MV with refresh method identified as complex, when you edit MV and click complex : code is generated:
alter materialized view …
with complex --this line is invalid.
To simulate this , please create MV using scripts included in the attachement.
test_mv.zip (358 Bytes)