I created materlized views in 9i.these views gets refreshed every 30 minutes.

All the sudden some of these views are not getting refreshed .
I see a compilation error. if i manually compile and refresh they are fine but not on thier own

they have same schema name on different box's.


Any help is much appreciated