根據表查詢索引資訊

raysuen發表於2017-01-20
索引
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章