Re: Oracle 8 partitioned index question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 29 Apr 1999 20:15:12 +0100
Message-ID: <925413521.14757.0.nnrp-11.9e984b29@news.demon.co.uk>

I have a vague feeling that I hit this about a year ago on 8.0.3. If it is a bug, a possible workaround is to swap the partition for a table (including indexes, without validation) then drop and create the index on the table, then swap back again.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Gregert Johnson wrote in message <3728A939.47AE6B8E_at_ctron.com>...
>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.
>
Received on Thu Apr 29 1999 - 14:15:12 CDT