Re: Index Pre Check

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 04 Mar 2005 21:50:43 +0100
Message-ID: <1gih21l3fj3aol0ggdtivuieoq58e70c3n@4ax.com>

On 4 Mar 2005 12:33:05 -0800, "Shasi" <v.sasikumar_at_gmail.com> wrote:

>I'm in the process of writing a procedure for automating the index
>creation....Parameters i pass will be tablename,new indexname,index
>type and column list(list of column seperated by commas as one string)
>
> How can i find whether already an index is associated with the same
>column list and the same position...
>
>
>Can u please help on it

user_indexes joined to user_ind_columns (or dba_indexes and dba_ind_columns)

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Mar 04 2005 - 14:50:43 CST