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