| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
ALL_INDEXTYPES displays information about the indextypes accessible to the current user.
Related Views
DBA_INDEXTYPES displays information about all indextypes in the database.
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:
|
|
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 |
See Also:
