Re: disabled function-based index

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)