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

Object Details

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

All indextypes

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the indextype
INDEXTYPE_NAME	VARCHAR2	(128)	Yes	Name of the indextype
IMPLEMENTATION_SCHEMA	VARCHAR2	(128)	Yes	Name of the schema for indextype implementation
IMPLEMENTATION_NAME	VARCHAR2	(128)	Yes	Name of indextype implementation
INTERFACE_VERSION	NUMBER			Version of indextype interface
IMPLEMENTATION_VERSION	NUMBER		Yes	Version of indextype implementation
NUMBER_OF_OPERATORS	NUMBER			Number of operators associated with the indextype
PARTITIONING	VARCHAR2	(10)		Kinds of local partitioning supported by the indextype
ARRAY_DML	VARCHAR2	(3)		Does this indextype support array dml
MAINTENANCE_TYPE	VARCHAR2	(14)		An indicator of whether the indextype is system managed or user managed

Query Text

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


SELECT OWNER
,      INDEXTYPE_NAME
,      IMPLEMENTATION_SCHEMA
,      IMPLEMENTATION_NAME
,      INTERFACE_VERSION
,      IMPLEMENTATION_VERSION
,      NUMBER_OF_OPERATORS
,      PARTITIONING
,      ARRAY_DML
,      MAINTENANCE_TYPE
FROM SYS.DBA_INDEXTYPES;

Dependencies

[top of page]

SYS.DBA_INDEXTYPES references the following:

SYS: INDOP$; INDTYPES$; OBJ$; TYPE$; USER$

SYS.DBA_INDEXTYPES is referenced by following:

PUBLIC: DBA_INDEXTYPES
SYS: DBMS_REPCAT_UTL4 - show dependent code