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) |
