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

Why does alter view recompile not works

From: Nicolas Bronke <news_at_TRINITY.de>
Date: Sat, 31 Jul 1999 20:28:36 +0200
Message-ID: <37a33230@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 - 13:28:36 CDT












Original text of this message













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