Get information on all the indexes you have access to using all_views : all_views « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. all_views

SQL>
SQL> desc all_views;
 Name                       Null?    Type
 ---------------------------

 OWNER                      NOT NULL VARCHAR2(30)
 VIEW_NAME                  NOT NULL VARCHAR2(30)
 TEXT_LENGTH                         NUMBER
 TEXT                                LONG
 TYPE_TEXT_LENGTH                    NUMBER
 TYPE_TEXT                           VARCHAR2(4000)
 OID_TEXT_LENGTH                     NUMBER
 OID_TEXT                            VARCHAR2(4000)
 VIEW_TYPE_OWNER                     VARCHAR2(30)
 VIEW_TYPE                           VARCHAR2(30)
 SUPERVIEW_NAME                      VARCHAR2(30)

SQL>
SQL> --select * from all_views;
SQL>