ALL_PART_TABLES

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

Related Views

• DBA_PART_TABLES provides such information for all partitioned tables in the database.

• USER_PART_TABLES provides such information for all partitioned tables owned by the current user. This view does not display the OWNER column.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	Owner of the partitioned table
  TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the partitioned table
  PARTITIONING_TYPE	VARCHAR2(7)		Type of partitioning (RANGE | HASH)
  SUBPARTITIONING_TYPE	VARCHAR2(7)		Type of subpartitioning (HASH | NONE)
  PARTITION_COUNT	NUMBER	NOT NULL	Number of partitions in this table
  DEF_SUBPARTITION_COUNT	NUMBER	NOT NULL	For a composite-partitioned table, the default number of subpartitions, if specified
  PARTITIONING_KEY_COUNT	NUMBER	NOT NULL	Number of columns in the partitioning key
  SUBPARTITIONING_KEY_COUNT	NUMBER	NOT NULL	For a composite-partitioned table, the number of columns in the subpartitioning key
  DEF_TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Default tablespace to be used when adding a partition
  DEF_PCT_FREE	NUMBER	NOT NULL	Default value of PCTFREE to be used when adding a partition
  DEF_PCT_USED	NUMBER	NOT NULL	Default value of PCTUSED to be used when adding a partition
  DEF_INI_TRANS	NUMBER	NOT NULL	Default value of INITRANS to be used when adding a partition
  DEF_MAX_TRANS	NUMBER	NOT NULL	Default value of MAXTRANS to be used when adding a partition
  DEF_INITIAL_EXTENT	VARCHAR2(40)		Default value of INITIAL to be used when adding a partition. DEFAULT if INITIAL was not specified.
  DEF_NEXT_EXTENT	VARCHAR2(40)		Default value of NEXT to be used when adding a partition. DEFAULT if NEXT was not specified.
  DEF_MIN_EXTENTS	VARCHAR2(40)		Default value of MINEXTENTS to be used when adding a partition. DEFAULT if MINEXTENTS was not specified.
  DEF_MAX_EXTENTS	VARCHAR2(40)		Default value of MAXEXTENTS to be used when adding a partition. DEFAULT if MAXEXTENTS was not specified.
  DEF_PCT_INCREASE	VARCHAR2(40)		Default value of PCTINCREASE to be used when adding a partition. DEFAULT if PCTINCREASE was not specified.
  DEF_FREELISTS	NUMBER	NOT NULL	Default value of FREELISTS to be used when adding a partition
  DEF_FREELIST_GROUPS	NUMBER	NOT NULL	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
  DEF_BUFFER_POOL	VARCHAR2(7)		Default buffer pool to be used when adding a partition