Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Uncompiled views
To get the answer to your question, query dba_errors.
Hth,
Sybrand Bakker, Oracle DBA
Lío <jgonzalezsuareNO_at_SPAMnexo.es> wrote in message
news:372fds4ps4577lmmsqlfe2nbus5rmqcg2r_at_4ax.com...
> 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)
Received on Wed Mar 22 2000 - 00:00:00 CST