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: Why does alter view recompile not works

Re: Why does alter view recompile not works

From: Louise Weiler <ljweiler_at_nycap.rr.com>
Date: Sat, 31 Jul 1999 17:26:43 -0400
Message-ID: <L5Ko3.942$va.26719@typhoon.nyroc.rr.com>


It depends on what the views are of. I have found that if I add columns to a table, and the view is based on "select * from table", then I have to drop and recreate (or "create or replace") the views. If, however, the view is of a few of the columns on a table, and I add columns to the table, the view is recreated with a recompile.

HTH
Louise

Nicolas Bronke wrote in message <37a33230_at_news.uk.ibm.net>...
>In one environment (8.03 and 7.3) I have some problems to recompile some
>views which have errors.
>The errors came from changing in views, from which their are depending.
>
>Therefore I use the recompile feature. But with some views it does not
work!
>If I use the original sql-statement there is no errors.
>
>What could be the reason for that (memory or so)?
>
>Kind regards
>Nicolas Bronke
>
>
Received on Sat Jul 31 1999 - 16:26:43 CDT

Original text of this message

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