ALL_XML_INDEXES

Previous Next JavaScript must be enabled to correctly display this content

4.143 ALL_XML_INDEXES

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`

See Also:

"DBA_XML_INDEXES"
"USER_XML_INDEXES"