ALL_INDEXTYPE_ARRAYTYPES displays information about the array types specified by the indextypes accessible to the current user.
DBA_INDEXTYPE_ARRAYTYPES displays information about the array types specified by all indextypes in the database.
USER_INDEXTYPE_ARRAYTYPES displays information about the array types specified by 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 |
BASE_TYPE_SCHEMA |
VARCHAR2(30) |
Name of the base type schema | |
BASE_TYPE_NAME |
VARCHAR2(30) |
Name of the base type name | |
BASE_TYPE |
VARCHAR2(30) |
Datatype of the base type | |
ARRAY_TYPE_SCHEMA |
VARCHAR2(30) |
NOT NULL |
Name of the array type schema |
ARRAY_TYPE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the array type name |