Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

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

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_INDEXTYPES

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

  • RANGE

  • HASH

  • HASH,RANGE

ARRAY_DML VARCHAR2(3)   Indicates whether the indextype supports array DML (YES) or not (NO)
MAINTENANCE_TYPE VARCHAR2(14)
Whether the indextype is system-managed or user-managed