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: disabled function-based index

Re: disabled function-based index

From: chao_ping <zhuchao_at_gmail.com>
Date: 8 Oct 2005 23:35:55 -0700
Message-ID: <1128839755.137573.314650@o13g2000cwo.googlegroups.com> 





He simply ask a simple question, function index's status.
Just check DBA_INDEXES.FUNCIDX_STATUS.



Maybe somebody did alter index disable, if he is hitting error, or used
rbo or some other reason, his index is not being used, and he thought
it was disabled.
Received on Sun Oct 09 2005 - 01:35:55 CDT












Original text of this message













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