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 -> Uncompiled views

Uncompiled views

From: Lío <jgonzalezsuareNO_at_SPAMnexo.es>
Date: 2000/03/21
Message-ID: <372fds4ps4577lmmsqlfe2nbus5rmqcg2r@4ax.com>#1/1

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 Tue Mar 21 2000 - 00:00:00 CST

Original text of this message

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