Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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

Related Views

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 - Indextype does not support local domain indexes

  • RANGE - Indextype can support range partitioned local user managed domain indexes

  • LOCAL - Indextype can support local system managed domain indexes (both range and list partitioned)

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)