Re: invalid views and indexes

In article <9if5k8$lk1$1_at_netnews.upenn.edu>, samuels_at_red.seas.upenn.edu says...
>
>can anyone explain why a view would be marked invalid if an index is dropped on
>the table that the view is
>referencing?
>thanks in advance (i've searched through the oracle doc's 8.0.5 and can't find
>anything).
>-maurice
>samuels_at_seas.upenn.edu

This changed in 7.3 when updatable join views were introduced. As the presence (or lack of) an index can change the set of updateable columns -- the view definition is invalidated when the base tables are altered in that fashion. The definition of the view needs to be recompiled to verify that the columns that were updateable still are and add any new ones that are now updateable.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp