查询用户的索引select index_name,table_name,tablespace_name, index_type,uniqueness , status from dba_indexes where owner='SCOTT';查询用户的索引列select index_name,table_name,column_name, index_owner,table_ownerfrom dba_ind_columnswhere table_owner='SCOTT';查看索引的各种初始化