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: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 07 Oct 2005 14:42:13 -0700
Message-ID: <1128721324.965912@yasure>


niy38_at_hotmail.com wrote:
> for unknown reason, one function-based index is disabled, what cause
> this?
> and which view I can use to check if it's enabled or disabled? the
> "status" in
> dba_indexes still show "valid" for this index.

On what basis are you determining that the index is invalid? What version of Oracle?

Look in all_ind_expressions, pull out the function, and try it in SQL*Plus to see if it is the index or the function.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Oct 07 2005 - 16:42:13 CDT

Original text of this message

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