Re: Index Questions

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: 14 Jul 2004 01:40:31 -0700
Message-ID: <b6beca79.0407140040.2ea8fab8@posting.google.com>

melliott42_at_yahoo.com (Michael) wrote in message 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?

Either

Query user_ind_columns and user_indexes for the relevant attributes and then use sql to write the sql or
export with the indexfile parameter.

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

ALTER INDEX .... REBUILD. you can use this to move indexes as well.

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

This rather depends on what you mean by errors, or indeed failing.

Do you have a specific problem in mind?

Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com Received on Wed Jul 14 2004 - 03:40:31 CDT