DBA_PART_TABLES

Oracle 11gR1

DBA_PART_TABLES displays the object-level partitioning information for all partitioned tables in the database. Its columns are the same as those in ALL_PART_TABLES.

Related Views

· ALL_PART_TABLES displays the object-level partitioning information for the partitioned tables accessible to the current user.

· USER_PART_TABLES displays the object-level partitioning information for the partitioned tables owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the partitioned table
TABLE_NAME	VARCHAR2(30)		Name of the partitioned table
PARTITIONING_TYPE	VARCHAR2(9)		Type of the partitioning method: · RANGE · HASH · SYSTEM · LIST · REFERENCE
SUBPARTITIONING_TYPE	VARCHAR2(7)		Type of the composite partitioning method: · NONE · RANGE · HASH · SYSTEM · LIST
PARTITION_COUNT	NUMBER		Number of partitions in the table
DEF_SUBPARTITION_COUNT	NUMBER		For a composite-partitioned table, the default number of subpartitions, if specified
PARTITIONING_KEY_COUNT	NUMBER		Number of columns in the partitioning key
SUBPARTITIONING_KEY_COUNT	NUMBER		For a composite-partitioned table, the number of columns in the subpartitioning key
STATUS	VARCHAR2(8)		If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID)
DEF_TABLESPACE_NAME	VARCHAR2(30)		Default tablespace to be used when adding a partition
DEF_PCT_FREE	NUMBER		Default value of PCTFREE to be used when adding a partition
DEF_PCT_USED	NUMBER		Default value of PCTUSED to be used when adding a partition
DEF_INI_TRANS	NUMBER		Default value of INITRANS to be used when adding a partition
DEF_MAX_TRANS	NUMBER		Default value of MAXTRANS to be used when adding a partition
DEF_INITIAL_EXTENT	VARCHAR2(40)		Default value of INITIAL (in Oracle blocks) to be used when adding a partition, or DEFAULT if no INITIAL value was specified
DEF_NEXT_EXTENT	VARCHAR2(40)		Default value of NEXT (in Oracle blocks) to be used when adding a partition, or DEFAULT if no NEXT value was specified
DEF_MIN_EXTENTS	VARCHAR2(40)		Default value of MINEXTENTS to be used when adding a partition, or DEFAULT if no MINEXTENTS value was specified
DEF_MAX_EXTENTS	VARCHAR2(40)		Default value of MAXEXTENTS to be used when adding a partition, or DEFAULT if no MAXEXTENTS value was specified
DEF_MAX_SIZE	VARCHAR2(40)		Default value of MAXSIZE to be used when adding a partition, or DEFAULT if no MAXSIZE value was specified
DEF_PCT_INCREASE	VARCHAR2(40)		Default value of PCTINCREASE to be used when adding a partition, or DEFAULT if no PCTINCREASE value was specified
DEF_FREELISTS	NUMBER		Default value of FREELISTS to be used when adding a partition
DEF_FREELIST_GROUPS	NUMBER		Default value of FREELIST GROUPS to be used when adding a partition
DEF_LOGGING	VARCHAR2(7)		Default LOGGING attribute to be used when adding a partition: · NONE · YES · NO · UNKNOWN
DEF_COMPRESSION	VARCHAR2(8)		Default compression to be used when adding a partition: · NONE · ENABLED · DISABLED · UNKNOWN
DEF_BUFFER_POOL	VARCHAR2(7)		Default buffer pool to be used when adding a partition: · DEFAULT · KEEP · RECYCLE · NULL
REF_PTN_CONSTRAINT_NAME	VARCHAR2(30)		Name of the partitioning referential constraint for reference-partitioned tables
INTERVAL	VARCHAR2(1000)		String of the interval value

Note:

1.

select owner, table_name, partitioning_type, partition_count, status, def_tablespace_name, def_logging, def_compression

from DBA_PART_TABLES;

OWNER	TABLE_NAME	PARTITIONING_ TYPE	PARTITION_ COUNT	STATUS	DEF_ TABLESPACE_ NAME	DEF_ LOGGING	DEF_ COMPRESSION
SYSTEM	LOGSTDBY$APPLY_PROGRESS	RANGE	1	VALID	SYSAUX	NONE	NONE
SYSTEM	LOGMNR_DICTSTATE$	RANGE	1	VALID	SYSAUX	YES	NONE
SYSTEM	LOGMNR_DICTIONARY$	RANGE	1	VALID	SYSAUX	YES	NONE
SYS	STREAMS$_APPLY_SPILL_MSGS_PART	LIST	1	VALID	SYSAUX	NONE	NONE
SYS	WRH$_FILESTATXS	RANGE	10	VALID	SYSTEM	NONE	NONE

Oracle data dictionary views

DBA_LOG_GROUP_COLUMNS

Oracle 11gR1

DBA_LOG_GROUP_COLUMNS describes all columns in the database that are specified in log groups.

Related Views

· ALL_LOG_GROUP_COLUMNS describes columns that are accessible to the current user and that are specified in log groups.

· USER_LOG_GROUP_COLUMNS describes columns that are owned by the current user and that are specified in log groups.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the log group definition
LOG_GROUP_NAME	VARCHAR2(30)	NOT NULL	Name of the log group definition
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table in which the log group is defined
COLUMN_NAME	VARCHAR2(4000)		Name of the column or attribute of the object type column specified in the log group definition
POSITION	NUMBER		Original position of the column or attribute in the definition of the object
LOGGING_PROPERTY	VARCHAR2(6)		Indicates whether the column or attribute would be supplementally logged (LOG) or not (NO LOG)

Oracle data dictionary views

DBA_LOG_GROUPS

Oracle 11gR1

DBA_LOG_GROUPS describes log group definitions on all tables in the database.

Related Views

· ALL_LOG_GROUPS describes the log group definitions on the tables accessible to the current user.

· USER_LOG_GROUPS describes the log group definitions on the tables owned by the current user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the log group definition
LOG_GROUP_NAME	VARCHAR2(30)	NOT NULL	Name of the log group definition
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table on which the log group is defined
LOG_GROUP_TYPE	VARCHAR2(19)		Type of the log group: · PRIMARY KEY LOGGING · UNIQUE KEY LOGGING · FOREIGN KEY LOGGING · ALL COLUMN LOGGING · USER LOG GROUP
ALWAYS	VARCHAR2(11)		Y indicates the log group is logged any time a row is updated; N indicates the log group is logged any time a member column is updated.
GENERATED	VARCHAR2(14)		Indicates whether the name of the supplemental log group was system generated (GENERATED NAME) or not (USER NAME)

Oracle data dictionary views

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

DBA_PARTIAL_DROP_TABS

Oracle 11gR1

DBA_PARTIAL_DROP_TABS describes all tables in the database that have partially completed DROP COLUMN operations. Its columns are the same as those in ALL_PARTIAL_DROP_TABS.

Related Views

· ALL_PARTIAL_DROP_TABS describes tables accessible to the current user that have partially completed DROP COLUMN operations. Such operations might have been interrupted by the user or by a system crash.

· USER_PARTIAL_DROP_TABS describes tables in the schema of the current user that have partially completed DROP COLUMN operations. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table

Oracle data dictionary views

DBA_UNUSED_COL_TABS

Oracle 11gR1

DBA_UNUSED_COL_TABS describes all tables in the database containing unused columns. Its columns are the same as those in ALL_UNUSED_COL_TABS.

Related Views

· ALL_UNUSED_COL_TABS describes the tables accessible to the current user that contain unused columns.

· USER_UNUSED_COL_TABS describes the tables owned by the current user that contain unused columns. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
COUNT	NUMBER		Number of unused columns

Oracle data dictionary views

DBA_RESUMABLE

Oracle 11gR1

DBA_RESUMABLE lists all resumable statements executed in the system.

Related View

USER_RESUMABLE lists resumable statements executed by the current user. This view does not display the USER_ID column.

Column	Datatype	NULL	Description
USER_ID	NUMBER		User ID Number of the Resumable Statement Owner
SESSION_ID	NUMBER		Session Identifier of the Resumable Statement
INSTANCE_ID	NUMBER		Instance Number of the Resumable Statement
COORD_INSTANCE_ID	NUMBER		Instance Number on which the Parallel Coordinator is Running
COORD_SESSION_ID	NUMBER		Session Identifier of the Parallel Coordinator
STATUS	VARCHAR2(9)		Status of the resumable statement: · RUNNING · SUSPENDED · TIMEOUT · ERROR · ABORTED
TIMEOUT	NUMBER		Timeout of the resumable statement
START_TIME	VARCHAR2(20)		Start time of the resumable statement
SUSPEND_TIME	VARCHAR2(20)		Last time the resumable statement was suspended. It is initialized to null.
RESUME_TIME	VARCHAR2(20)		Last time the suspended resumable statement was resumed. It is initialized to null.
NAME	VARCHAR2(4000)		Name given in the resumable clause of the resumable statement
SQL_TEXT	VARCHAR2(1000)		Resumable statement, selected from the V$SQL view
ERROR_NUMBER	NUMBER		Error code of the last correctable error. When STATUS is set to RUNNING, its value will be set to 0.
ERROR_PARAMETER1	VARCHAR2(80)		First parameter for the error message (null if no error)
ERROR_PARAMETER2	VARCHAR2(80)		Second parameter for the error message (null if no error)
ERROR_PARAMETER3	VARCHAR2(80)		Third parameter for the error message (null if no error)
ERROR_PARAMETER4	VARCHAR2(80)		Forth parameter for the error message (null if no error)
ERROR_PARAMETER5	VARCHAR2(80)		Fifth parameter for the error message (null if no error)
ERROR_MSG	VARCHAR2(4000)		Error message corresponding to ERROR_NUMBER. It will be null when ERROR_NUMBER is null.

Oracle data dictionary views