Re: Uncompiled views

On Wed, 22 Mar 2000 07:21:22 +0100, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>To get the answer to your question, query dba_errors.

I've done it, but dba_errors is empty.
I remind you that my invalid objects are VIEWS and that if I issue the command:
Alter view <myinvalidview> compile;
the view is no longer invalid (for some days).

--
Julio César Glez Suarez
Xixón, Asturies, Spain
jgonzalezsuareNO_at_SPAMnexo.es (Remove NO SPAM)