Re: Oracle8 index unusable

There is a bug in 8.0.3.0 using the ALTER INDEX index_name REBUILD command. You must upgrade to 8.0.3.1 patchset to resolve the problem.

Shawn

In article <01bd15b1$65ca66c0$0fd3aec7_at_laptop>,   "Dave Sisk" <davesisk_at_travelin.com> wrote:
>
> Try ALTER INDEX index_name REBUILD;
>
> Regards,
> Dave Sisk
>
> Patrick Tan <ptan_at_mindspring.com> wrote in article
> <34A943F8.19B73DB_at_mindspring.com>...
> > I split a partition table and the local index partition become
> > unusable. How can I make the partition index usable again without
> > dropping and recreating the index? Thanks.
> >
> >
> > Patrick
> >
> >

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet