set lines 300;
col INDEX_NAME format a30;
col TABLE_NAME format a30;
col TABLESPACE_NAME format a15;
select INDEX_NAME
     , UNIQUENESS
     , TABLE_NAME
     , TABLESPACE_NAME
     , INITIAL_EXTENT
     , NEXT_EXTENT  
  from user_indexes 
 order by TABLE_NAME, INDEX_NAME;

INDEX_NAME                     UNIQUENESS                  TABLE_NAME                     TABLESPACE_NAME  INITIAL_EXTENT     NEXT_EXTENT
------------------------------ --------------------------- ------------------------------ --------------- --------------- ---------------
SUBJECT_SEGMENT_T_PKEY         UNIQUE                      SUBJECT_SEGMENT_T              USERS                    327680
SUBJECT_T_PKEY                 UNIQUE                      SUBJECT_T                      USERS                   1064960
TEL_NO_T_PKEY                  UNIQUE                      TEL_NO_T                       USERS                   2539520



col INDEX_NAME format a40;
col TABLE_NAME format a30;
col COLUMN_NAME format a30;
select INDEX_NAME
     , COLUMN_NAME
     , COLUMN_POSITION
     , TABLE_NAME
  from user_ind_columns
 order by TABLE_NAME, INDEX_NAME, COLUMN_POSITION;

INDEX_NAME                               COLUMN_NAME                    COLUMN_POSITION TABLE_NAME
---------------------------------------- ------------------------------ --------------- ------------------------------
SUBJECT_SEGMENT_T_PKEY                   SUBJECT_CD                                   1 SUBJECT_SEGMENT_T
SUBJECT_SEGMENT_T_PKEY                   SEGMENT_CD                                   2 SUBJECT_SEGMENT_T
SUBJECT_T_PKEY                           SUBJECT_CD                                   1 SUBJECT_T
TEL_NO_T_PKEY                            MEMBER_ID                                    1 TEL_NO_T
TEL_NO_T_PKEY                            SEQ_NO                                       2 TEL_NO_T