Oracle教程 2023-03-25

Oracle 视图 ALL_XML_INDEXES 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图ALL_XML_INDEXES显示拥有者的XML索引汇总信息。

ALL_XML_INDEXES包含的主要信息如下：
1. OWNER：拥有者名称;
2. INDEX_NAME：索引名称;
3. TABLE_NAME：索引关联的表名称;
4. TABLE_OWNER：表的拥有者;
5. COLUMN_NAME：索引关联列;
6. TYPE：索引类型（全文本索引，唯一性索引等）
7. GENERATING_FUNCTION：索引构建函数.

使用ALL_XML_INDEXES视图可以查询全文本索引的汇总信息，便于管理、排查问题。可以根据OWNER，TABLE_NAME， COLUMN_NAME等条件组合查询相关的索引信息。如下：

SELECT owner, index_name, table_name, table_owner, column_name, type, generating_function
FROM all_xml_indexes
WHERE owner = ‘OWNER_NAME’
AND table_name = ‘TABLE_NAME’;

官方英文解释

ALL_XML_INDEXES describes the XML indexes accessible to the current user.

Related Views

DBA_XML_INDEXES describes all XML indexes in the database.
USER_XML_INDEXES describes the XML indexes owned by the current user. This view does not display the INDEX_OWNER column.

Column	Datatype	NULL	Description
`INDEX_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the XML index
`INDEX_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the XML index
`TABLE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the indexed object
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the indexed object
`TYPE`	`VARCHAR2(10)`		Type of the indexed column: `REPOSITORY` `BINARY` `CLOB in OR` `CLOB`
`INDEX_TYPE`	`VARCHAR2(27)`		Type of the index: `STRUCTURED` `STRUCTURED and UNSTRUCTURED` `UNSTRUCTURED`
`PATH_TABLE_NAME`	`VARCHAR2(128)`		Name of the path table
`PARAMETERS`	`XMLTYPE`		Indexed paths and Scheduler job information
`ASYNC`	`VARCHAR2(9)`		Asynchronous index type: `ON-COMMIT` `MANUAL` `EVERY` `ALWAYS`
`STALE`	`VARCHAR2(5)`		Indicates whether the index type is stale (`TRUE`) or not (`FALSE`)
`PEND_TABLE_NAME`	`VARCHAR2(128)`		Name of the pending table
`EX_OR_INCLUDE`	`VARCHAR2(8)`		Path subsetting: `INCLUDE` `EXCLUDE` `FULLY IX`

本站中文解释

官方英文解释

相关推荐