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(30) NOT NULL Owner of the XML index
INDEX_NAME VARCHAR2(30) NOT NULL Name of the XML index
TABLE_OWNER VARCHAR2(30) NOT NULL Owner of the indexed object
TABLE_NAME VARCHAR2(30) 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(30)   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(30)   Name of the pending table
EX_OR_INCLUDE VARCHAR2(8)   Path subsetting:

  • INCLUDE

  • EXCLUDE

  • FULLY IX

See Also: