Re: Database and Views

Hi!

> > What should I do if only one view was missing?
> > If multiple views were missing what should be done?

How did you do the refresh?

Maybe it's just matter of missing privileges, thus not allowing your views to compile?

Try this: select owner, view_name from dba_views where status = 'INVALID'

that should show you all invalid views.

Tanel Poder
a DBA Received on Sun May 27 2001 - 10:33:32 CDT