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