ALL_INDEXTYPE_ARRAYTYPES

ALL_INDEXTYPE_ARRAYTYPES displays information about the array types specified by the indextypes accessible to the current user.

Related Views

  • 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(128)

NOT NULL

Owner of the indextype

INDEXTYPE_NAME

VARCHAR2(128)

NOT NULL

Name of the indextype

BASE_TYPE_SCHEMA

VARCHAR2(128)

 

Name of the base type schema

BASE_TYPE_NAME

VARCHAR2(128)

 

Name of the base type name

BASE_TYPE

VARCHAR2(30)

 

Datatype of the base type

ARRAY_TYPE_SCHEMA

VARCHAR2(128)

NOT NULL

Name of the array type schema

ARRAY_TYPE_NAME

VARCHAR2(128)

NOT NULL

Name of the array type name