Re: Uncompiled views

In article <rg0hdsclduk37a58qkgdnv0v1a7duhkjui_at_4ax.com>, Lío <jgonzalezsuareNO_at_SPAMnexo.es> wrote:

> >To get the answer to your question, query dba_errors.
>
> I've done it, but dba_errors is empty.

A better bet to get error messages on views is to use show errors view scott.emp_view
in sqlplus.

> 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).

As to your main question I'm completely stumped.

mel

--
I've lived my life in the valleys
I've lived my life on the hills
I've lived my life on alchohol
I've lived my life on pills


Sent via Deja.com http://www.deja.com/
Before you buy.