eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_INDEXTYPE_ARRAYTYPES

Object Details

Object Name:	DBA_INDEXTYPE_ARRAYTYPES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All array types specified by the indextype

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the indextype
INDEXTYPE_NAME	VARCHAR2	(128)	Yes	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)	Yes	Name of the array type schema
ARRAY_TYPE_NAME	VARCHAR2	(128)	Yes	Name of the array type name

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      INDEXTYPE_NAME
,      BASE_TYPE_SCHEMA
,      BASE_TYPE_NAME
,      BASE_TYPE
,      ARRAY_TYPE_SCHEMA
,      ARRAY_TYPE_NAME
FROM SYS.DBA_INDEXTYPE_ARRAYTYPES;

Dependencies

[top of page]

SYS.DBA_INDEXTYPE_ARRAYTYPES references the following:

SYS: INDARRAYTYPE$; OBJ$; USER$

SYS.DBA_INDEXTYPE_ARRAYTYPES is referenced by following:

PUBLIC: DBA_INDEXTYPE_ARRAYTYPES