DBA_INDEXTYPES

Friday, November 14, 2008

DBA_INDEXTYPES describes all indextypes in the database. Its columns are the same as those in ALL_INDEXTYPES.

Related Views

· ALL_INDEXTYPES displays information about the indextypes accessible to the current user.

· USER_INDEXTYPES displays information about the indextypes owned by the current user.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the indextype
`INDEXTYPE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the indextype
`IMPLEMENTATION_SCHEMA`	`VARCHAR2(30)`	`NOT NULL`	Name of the schema for the indextype implementation (that is, containing the indextype operators)
`IMPLEMENTATION_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the indextype implementation type
`INTERFACE_VERSION`	`NUMBER`		Version of the indextype interface
`IMPLEMENTATION_VERSION`	`NUMBER`	`NOT NULL`	Version of the indextype implementation
`NUMBER_OF_OPERATORS`	`NUMBER`		Number of operators associated with the indextype
`PARTITIONING`	`VARCHAR2(10)`		Kinds of local partitioning supported by the indextype: · `NONE` · `RANGE` · `HASH` · `HASH,RANGE`
`ARRAY_DML`	`VARCHAR2(3)`		Indicates whether the indextype supports array DML (`YES`) or not (`NO`)
`MAINTENANCE_TYPE`	`VARCHAR2(14)`		Indicates whether the indextype is system-managed (`SYSTEM_MANAGED`) or user-managed (`USER_MANAGED`)

Note:

1. SELECT * FROM DBA_INDEXTYPES;