Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Views and triggers invalidated after creating and/or dropping ind

Re: Views and triggers invalidated after creating and/or dropping ind

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Fri, 17 Nov 2000 14:57:15 EST
Message-Id: <10683.122409@fatcity.com> 





It is normal behaviour due to dependencies and it is applicable to all
oracle versions including 7.3.4.


Just recompile those invalids on fly.


Regards


Rafiq




From: Alex Hillman <alex_hillman_at_physia.com>
Reply-To: ORACLE-L_at_fatcity.com


To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Subject: Views and triggers invalidated after creating and/or dropping ind
Date: Fri, 17 Nov 2000 09:55:23 -0800



Oracle 8.1.6.2, Sun Solaris 7.



Anybody have any idea why dropping indexes can cause invalidation of views?



Alex Hillman





Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.



Share information about yourself, create your own public profile at 
http://profiles.msn.com.
Received on Fri Nov 17 2000 - 13:57:15 CST












Original text of this message













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