eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.USER_XML_INDEXES

Object Details

Object Name:	USER_XML_INDEXES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of the user's own XMLType indexes

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INDEX_NAME	VARCHAR2	(128)	Yes	Name of the XML index
TABLE_OWNER	VARCHAR2	(128)	Yes	Username of the owner of the indexed object
TABLE_NAME	VARCHAR2	(128)	Yes	Name of the indexed object
TYPE	VARCHAR2	(10)		Type of indexed column (CLOB, CSX, CLOB_IN_OR, REPOSITORY, OR)
INDEX_TYPE	VARCHAR2	(27)		Index Type (Structured, Unstructured or both)
PATH_TABLE_NAME	VARCHAR2	(128)		Name of the PATH TABLE
PARAMETERS	XMLTYPE	(64)		Structured index groups, path subsetting xpaths and scheduler job information
ASYNC	VARCHAR2	(9)		Asynchronous index type
STALE	VARCHAR2	(5)		Stale index type
PEND_TABLE_NAME	VARCHAR2	(128)		Name of the PENDING TABLE
EX_OR_INCLUDE	VARCHAR2	(8)		Path Subsetting (Include or Exclude)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INDEX_NAME
,      TABLE_OWNER
,      TABLE_NAME
,      TYPE
,      INDEX_TYPE
,      PATH_TABLE_NAME
,      PARAMETERS
,      ASYNC
,      STALE
,      PEND_TABLE_NAME
,      EX_OR_INCLUDE
FROM SYS.USER_XML_INDEXES;

Dependencies

[top of page]

SYS.USER_XML_INDEXES references the following:

SYS: IND$; OBJ$; STANDARD - show dependent code; USER$; XMLTYPE
XDB: XDB$DXPTAB; XDB$XTAB

SYS.USER_XML_INDEXES is referenced by following:

PUBLIC: USER_XML_INDEXES