ALL_PART_TABLES

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

Related Views

DBA_PART_TABLES displays the object-level partitioning information for all partitioned tables in the database.
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	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 method: `RANGE` `HASH` `SYSTEM` `LIST`
`SUBPARTITIONING_TYPE`	`VARCHAR2(7)`	Type of composite partitioning method: `NONE` `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. `DEFAULT` if `INITIAL` was not specified.
`DEF_NEXT_EXTENT`	`VARCHAR2(40)`	Default value of `NEXT` (in Oracle blocks) 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`)