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博客 ” ，链接：https://blog.itpub.net/28572479/viewspace-2132741/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
5.6单实例安装
下一篇：
mysql 5.6 半同步主从安装
请登录后发表评论
登录
全部评论
