查看一个表上的索引,及索引属于哪张表

select * from dba_indexes where table_name ='T_USER_ROOT';
select * from dba_indexes where index_name ='INDX_T_USER_ROOT$SSOID'

原文地址:https://www.cnblogs.com/weixun/p/3002539.html