Re: Index Questions

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 14 Jul 2004 01:45:26 GMT
Message-ID: <Xns9525BECF22A7SunnySD@68.1.17.6>

melliott42_at_yahoo.com (Michael) wrote in news:91721cf.0407131451.737d98b_at_posting.google.com:

> Hello,
>
> In Oracle 8i on Solaris how can I:
>
> 1. Determine the SQL used to create an existing index?

Google is your friend.
You don't need to (re)create it explicitly

ALTER INDEX <INDEX_NAME> REBUILD.......

> 2. Rebuild an Index that may be corrupt or have
> invalid data?

Define "corrupt".
Explain how/why "invalid data" got into the index. What is to prevent the index from going "bad" in the future?

> 3. Look for any errors that may have occured as a
> result of an Index Primary\Foreign Key failing?

EXACTLY how can a PK/FK "fail"?

I suspect you have a problem & are grasping at straws. Received on Tue Jul 13 2004 - 20:45:26 CDT