Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Uncompiled views
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