DBA_NESTED_TABLES

Oracle 11gR1

DBA_NESTED_TABLES describes all nested tables contained in all tables in the database. Its columns are the same as those in ALL_NESTED_TABLES.

Related Views

· ALL_NESTED_TABLES describes the nested tables in tables accessible to the current user.

· USER_NESTED_TABLES describes nested tables owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the nested table
TABLE_NAME	VARCHAR2(30)		Name of the nested table
TABLE_TYPE_OWNER	VARCHAR2(30)		Owner of the type of which the nested table was created
TABLE_TYPE_NAME	VARCHAR2(30)		Name of the type of the nested table
PARENT_TABLE_NAME	VARCHAR2(30)		Name of the parent table containing the nested table
PARENT_TABLE_COLUMN	VARCHAR2(4000)		Column name of the parent table that corresponds to the nested table
STORAGE_SPEC	VARCHAR2(30)		Whether storage for the nested table is USER-SPECIFIED or DEFAULT
RETURN_TYPE	VARCHAR2(20)		Return type of the varray column (LOCATOR | VALUE)
ELEMENT_SUBSTITUTABLE	VARCHAR2(25)		Indicates whether the nested table element is substitutable (Y) or not (N)

Note:

1.

select * from DBA_NESTED_TABLES;

OWNER	TABLE_NAME	TABLE_ TYPE_ OWNER	TABLE_ TYPE_ NAME	PARENT_TABLE_NAME	PARENT_TABLE_ COLUMN	STORAGE_ SPEC	RETURN_ TYPE	ELEMENT_ SUBSTITUTABLE
WMSYS	WM$EVENT_AUX_PARAMS_NT	WMSYS	WM$NV_PAIR_NT_TYPE	WM$EVENT_QUEUE_TABLE	"USER_DATA"."AUX_PARAMS"	DEFAULT	VALUE	N
SYS	SYSNTLCMA3vg9TlLgRAAUTyMV9w==	SYS	KUPC$_FILELIST	AQ$_KUPC$DATAPUMP_QUETAB_P	TREAT("USER_DATA" AS "KUPC$_FILE_LIST")."FILELIST"	DEFAULT	VALUE	N
SYS	SYSNTLCMA3vg/TlLgRAAUTyMV9w==	SYS	KU$_LOGENTRY	AQ$_KUPC$DATAPUMP_QUETAB_P	TREAT("USER_DATA" AS "KUPC$_BAD_FILE")."ERROR"	DEFAULT	VALUE	N
SYS	SYSNTLCMA3vhBTlLgRAAUTyMV9w==	SYS	KU$_LOGENTRY	AQ$_KUPC$DATAPUMP_QUETAB_P	TREAT("USER_DATA" AS "KUPC$_WORKER_LOG_ENTRY")."WIP"	DEFAULT	VALUE	N
SYS	SYSNTFqMXMbeqFOvgRAADuiMN8g==	SYS	KUPC$_FILELIST	KUPC$DATAPUMP_QUETAB	TREAT("USER_DATA" AS "KUPC$_FILE_LIST")."FILELIST"	DEFAULT	VALUE	N
SYS	SYSNTFqMXMbesFOvgRAADuiMN8g==	SYS	KU$_LOGENTRY	KUPC$DATAPUMP_QUETAB	TREAT("USER_DATA" AS "KUPC$_BAD_FILE")."ERROR"	DEFAULT	VALUE	N
SYS	SYSNTFqMXMbeuFOvgRAADuiMN8g==	SYS	KU$_LOGENTRY	KUPC$DATAPUMP_QUETAB	TREAT("USER_DATA" AS "KUPC$_WORKER_LOG_ENTRY")."WIP"	DEFAULT	VALUE	N
WMSYS	WM$VERSIONED_TABLES_UNDO_CODE	WMSYS	WM$ED_UNDO_CODE_TABLE_TYPE	WM$VERSIONED_TABLES	UNDO_CODE	DEFAULT	VALUE	N
SYS	WRI$_SQLSET_WORKSPACE_CPLANS	SYS	SQL_PLAN_TABLE_TYPE	WRI$_SQLSET_WORKSPACE	SQL_PLAN	DEFAULT	VALUE	Y

Oracle data dictionary views