Re: disabled function-based index

niy38_at_hotmail.com wrote:
> the status of index is still valid.
>
> I have form running error with
> the index is disabled, after I alter index xxxx enable, everything
> is just fine.
>
> I'd like to know which view I can see the index disabled or enabled.
>
> version is 8.1.7.1

Before you think of anything else patch to 8.1.7.4. There is no reason I can think of to be in 8.1.7.1.

Then look at all_indexes or dba_indexes.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)