SQL> select index_name from all_indexes where owner='ZDWY';INDEX_NAME
------------------------------
CREAT
DEPARTMENTNO
EXPERTNO
FORUM1
FORUM2
FORUMNO
IDNO
IDNO_INDEX
IDNO_MED
ILLNO
PBSYSCATCOLDICT_IDX
PBSYSCATFRMTS_IDX
PBSYSCATPBT_IDX
PBSYSCATVLDS_IDX
PBSYSPBE_IDX
RE_TITLENO
SPECNO
STATSNO
TITLENO
TVIDINDEX_NAME
------------------------------
USERNAMENO
YYGHNO