dear sir ,

Limitations I am not knowing them.

But prebuilt option saved me once when I renamed my source table and then drop that table itself and Materialized view was in hanging stage.

Thanks to Julian for it !!!

bye
viraj