Re: Uncompiled views

Hi,
 check, whether the views are dependend on other stored objects (packages, functions, procedures) compiling these things will invalidate  your views - they 'll fix themselves once they are used for the first time.

Karsten

In article <372fds4ps4577lmmsqlfe2nbus5rmqcg2r_at_4ax.com>, Lío <jgonzalezsuareNO_at_SPAMnexo.es> wrote:
> I've posted here a question about views that fail during the import
> process, but now I've realized that the problem is not related with
> import but with the views.
>
> When I query the view obj looking for invalid objects, I find
> sometimes some views, which I compile (or just describe) and they
> loose their invalid status.
>
> Today, I've done this:
> EXEC DBMS_UTILITY.COMPILE_SCHEMA('myschema');
> and the invalid status views have increased in number.
>
> What the hell is wrong with this views?
>
> --
> Julio César Glez Suarez
> Xixón, Asturies, Spain
> jgonzalezsuareNO_at_SPAMnexo.es (Remove NO SPAM)
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 22 2000 - 00:00:00 CST