Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Uncompiled views

Re: Uncompiled views

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/22
Message-ID: <953707260.13094.1.pluto.d4ee154e@news.demon.nl>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US