Re: Oracle 8 partitioned index question

From: <acedba_at_my-dejanews.com>
Date: Fri, 07 May 1999 13:14:45 GMT
Message-ID: <7gup01$50b$1@nnrp1.deja.com>

Whoa! 8.0.3! Get thee to a more recent version (like 8.0.5)!! I pulled out a LOT of hair over 8.0.3. Way too many bugs.

In article <3728A939.47AE6B8E_at_ctron.com>, Gregert Johnson <gregj_at_ctron.com> wrote:
> Hello -
>
> Can anyone cast light on how to use the command ALTER TABLE ttt MODIFY
PARTITION ppp REBUILD UNUSABLE LOCAL INDEXES? We keep
> getting error message ORA-0152, "index or partition of index unusable",
accompanied by ORA-0604 (recursive SQL error). We're
> confused, because we thought the purpose of the command was in fact to make
unusable indexes usable again. The version of Oracle
> we're using is 8.03.
>
> Thanks.
>
> -- Greg Johnson
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 08:14:45 CDT