Re: Need an SQL*Plus script to show indexes on a given table

Hi there.
Just use the Views:

DBA_IND_COLUMNS  -- for all indexes on the db
USER_IND_COLUMNS -- for you indexes
ALL_IND_COLUMNS  -- for indexes you have access to

Angelo.
> Could someone please post an SQL*Plus script that will list the
> indexes and the fields in those indexes for a given table? Thanks!
Received on Tue Feb 03 1998 - 00:00:00 CST