根據表查詢索引資訊

SELECT     ui.table_name,     ui.TABLE_TYPE,     ui.INDEX_NAME,     ui.INDEX_TYPE,     uic.TABLE_OWNER,     wm_concat (uic.COLUMN_NAME) columns FROM     dba_indexes ui,     dba_IND_COLUMNS uic WHERE     ui.INDEX_NAME (+) = uic.INDEX_NAME AND ui.INDEX_NAME = UPPER ('IDX_FOR_OFF_ONOFFLINEID') GROUP BY     ui.table_name,     ui.TABLE_TYPE,     ui.INDEX_NAME,     ui.INDEX_TYPE,     uic.TABLE_OWNER;

SELECT     ui.table_name,     ui.TABLE_TYPE,     ui.INDEX_NAME,     ui.INDEX_TYPE,     uic.TABLE_OWNER,     wm_concat (uic.COLUMN_NAME) columns FROM     dba_indexes ui,     dba_IND_COLUMNS uic WHERE     ui.INDEX_NAME (+) = uic.INDEX_NAME AND ui.TABLE_NAME = UPPER ('IDX_FOR_OFF_ONOFFLINEID') GROUP BY     ui.table_name,     ui.TABLE_TYPE,     ui.INDEX_NAME,     ui.INDEX_TYPE,     uic.TABLE_OWNER;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28572479/viewspace-2132741/，如需轉載，請注明出處，否則将追究法律責任。

轉載于:http://blog.itpub.net/28572479/viewspace-2132741/