ALL_PART_TABLES

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

Related Views

• DBA_PART_TABLES describes the object-level partitioning information for all partitioned tables in the database.
• USER_PART_TABLES describes 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(7)		Type of partitioning (RANGE | HASH | SYSTEM | LIST)
  SUBPARTITIONING_TYPE	VARCHAR2(7)		Type of subpartitioning (NONE | HASH | SYSTEM | LIST)
  PARTITION_COUNT	NUMBER		Number of partitions in this 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
  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 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		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)
  DEF_COMPRESSION	VARCHAR2(8)		Default compression to be used when adding a partition (NONE | ENABLED | DISABLED)
  DEF_BUFFER_POOL	VARCHAR2(7)		Default buffer pool to be used when adding a partition (DEFAULT | KEEP | RECYCLE)

  See Also: "DBA_PART_TABLES" "USER_PART_TABLES"