Re: index in SQL*Plus

This is a fragment of my DBA etabs.sql script, which I use since 1987 (-: for Oracle 5, 6, 7, 8, 9 :-)

--
============================================================================
START defcol.sql
column bytes format 999,999,999,990
column tot_bytes like bytes
column max_bytes like bytes
column contigious_bytes like bytes
column tablespace_name format a16
column next_extent format 9999,999,990
...
--
============================================================================
TTITLE 'SCHEMA: &schemaname, USER_INDEXES - DESCRIPTION OF THE USERS OWN
INDEXES'
BREAK ON TABLE_TYPE SKIP 5 ON TABLE_NAME

SELECT
  TABLE_TYPE


 ,TABLE_NAME

 ,INDEX_NAME

 ,UNIQUENESS

 ,INI_TRANS

 ,MAX_TRANS

 ,INITIAL_EXTENT

 ,NEXT_EXTENT

 ,MAX_EXTENTS

 ,PCT_INCREASE


 ,TABLESPACE_NAME


FROM USER_INDEXES
ORDER BY TABLE_TYPE, TABLE_NAME, INDEX_NAME ;
--
============================================================================
TTITLE 'SCHEMA: &schemaname, USER_IND_COLUMNS - COLUMNS COMPRISING USERS
INDEXES OR ON USERS TABLES'
BREAK ON TABLE_NAME SKIP 1 ON INDEX_NAME

SELECT
  TABLE_NAME, INDEX_NAME, COLUMN_NAME, COLUMN_POSITION, COLUMN_LENGTH
FROM USER_IND_COLUMNS
ORDER BY TABLE_NAME, INDEX_NAME, COLUMN_POSITION ;
--
============================================================================
Denis ALEXANDRE
alex _at_ alexnet . fr

"chess hazlett" <puneyrf_f_unmyrgg_at_enlgurba.pbz> a écrit dans le message de
news: Xns92BF7C74F8F2Bpuneyrffunmyrggenlgu_at_138.126.254.210...
> Anyone know how to find the index of a table in SQL*Plus (or, for that
> matter, PL/SQL would work, too) ?
>
> Thanks.