oracle 查看表的索引信息

1.select * from user_indexes where table_name='PAMSODT0P02'

2.select * from user_ind_columns  where index_name='IDX_PAMSODT0P02_LOCATOR'

 

posted @ 2015-01-23 15:01  一切随缘吧  阅读(540)  评论(0编辑  收藏  举报