Re: Index's on a table

From: HansF <News.Hans_at_telus.net>
Date: Mon, 21 Mar 2005 16:10:04 GMT
Message-Id: <pan.2005.03.21.17.11.26.869634@telus.net>

On Mon, 21 Mar 2005 15:52:53 +0000, Tom wrote:

> 9.2.0.4
> RHEL 3
>
> Anyone tell me how to find out what indexes exist against a given table?
>

Docco is useful.. http://docs.oracle.com will get you to the
[Oracle9i Database] Reference manual.  See ???_INDEXES ???={ALL, USER,
DBA} depending on needs & privileges.

In SQLPLus, use something like ...

SELECT {useful columns}
FROM ???_INDEXES; In Enterprise Manager, expand schemas to get the same info.

/FGB Received on Mon Mar 21 2005 - 10:10:04 CST