Re: Oracle8 index unusable

From: Dave Sisk <davesisk_at_travelin.com>
Date: 1997/12/31
Message-ID: <01bd15b1$65ca66c0$0fd3aec7@laptop>#1/1

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
>
>
Received on Wed Dec 31 1997 - 00:00:00 CST

This message: [ Message body ]
Next message: hchen_at_cc.memphis.edu: "Help: oracle space problem. Error code:ORA-01652"
Previous message: Patrick Tan: "Oracle8 index unusable"
In reply to: Patrick Tan: "Oracle8 index unusable"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US