materilized views in 9i

[prodadmin]

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

[sambavan]

Can you please post the compilation error message?

Sam

[prodadmin]

I don't get any msg but in the column next to compile in OEM ,I see a compile_error.

Thanks...

[marist89]

GUI, bah.