3.141 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 theINDEX_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the XML index |
|
|
|
Name of the XML index |
|
|
|
Owner of the indexed object |
|
|
|
Name of the indexed object |
|
|
|
Type of the indexed column:
|
|
|
|
Type of the index:
|
|
|
|
Name of the path table |
|
|
|
Indexed paths and Scheduler job information |
|
|
|
Asynchronous index type:
|
|
|
|
Indicates whether the index type is stale ( |
|
|
|
Name of the pending table |
|
|
|
Path subsetting:
|
See Also: