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.CDB_XML_INDEXES

Object Details

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

Description of all XML indexes in the database in all containers

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INDEX_OWNER	VARCHAR2	(30)	Yes	Username of the owner of the XML index
INDEX_NAME	VARCHAR2	(30)	Yes	Name of the XML index
TABLE_OWNER	VARCHAR2	(30)	Yes	Username of the owner of the indexed object
TABLE_NAME	VARCHAR2	(30)	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	(30)		Name of the PATH TABLE
PARAMETERS	XMLTYPE	(80)		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	(30)		Name of the PENDING TABLE
EX_OR_INCLUDE	VARCHAR2	(8)		Path Subsetting (Include or Exclude)
CON_ID	NUMBER			container id

Query Text

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


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

Dependencies

[top of page]

SYS.CDB_XML_INDEXES references the following:

SYS: STANDARD - show dependent code; XMLTYPE

SYS.CDB_XML_INDEXES is referenced by following:

PUBLIC: CDB_XML_INDEXES