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
PATH_TABLE_NAME VARCHAR2(30) NOT NULL 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
TYPE VARCHAR2(10)   Type of the indexed column:
  • REPOSITORY

  • CSX

  • CLOB in OR

  • CLOB

EX_OR_INCLUDE VARCHAR2(8)   Path subsetting:
  • INCLUDE

  • EXCLUDE

  • FULLY IX