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(128)`	Owner of the partitioned table
`TABLE_NAME`	`VARCHAR2(128)`	Name of the partitioned table
`PARTITIONING_TYPE`	`VARCHAR2(9)`	Type of the partitioning method: `UNKNOWN` - Not specified See Also: the `*_TABLES` view `RANGE` `HASH` `SYSTEM` `LIST` `REFERENCE`
`SUBPARTITIONING_TYPE`	`VARCHAR2(9)`	Type of the composite partitioning method: `NONE` - Not subpartitioned See Also: the `*_TABLES` view `RANGE` `HASH` `SYSTEM` `LIST` `REFERENCE`
`PARTITION_COUNT`	`NUMBER`	Number of partitions in the table. For interval partitioned tables, the value of this column is always `1048575`.
`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` - Not specified See Also: the `*_TABLES` view `YES` `NO`
`DEF_COMPRESSION`	`VARCHAR2(8)`	Default compression to be used when adding a partition: `NONE` - Not specified See Also: the `*_TABLES` view `ENABLED` `DISABLED`
`DEF_COMPRESS_FOR`	`VARCHAR2(30)`	Default compression for what kind of operations to be used when adding a partition: `BASIC` `ADVANCED` `QUERY LOW` `QUERY HIGH`¹ `ARCHIVE LOW`¹ `ARCHIVE HIGH`¹ `UNKNOWN` `NULL`
`DEF_BUFFER_POOL`	`VARCHAR2(7)`	Default buffer pool to be used when adding a partition: `DEFAULT` `KEEP` `RECYCLE` `NULL`
`DEF_FLASH_CACHE`	`VARCHAR2(7)`	Default Database Smart Flash Cache hint to be used when adding a partition: `DEFAULT` `KEEP` `NONE` Solaris and Oracle Linux functionality only.
`DEF_CELL_FLASH_CACHE`	`VARCHAR2(7)`	Default cell flash cache hint to be used when adding a partition: `DEFAULT` `KEEP` `NONE` See Also: Oracle Exadata Storage Server Software documentation for more information
`REF_PTN_CONSTRAINT_NAME`	`VARCHAR2(128)`	Name of the partitioning referential constraint for reference-partitioned tables
`INTERVAL`	`VARCHAR2(1000)`	String of the interval value
`IS_NESTED`	`VARCHAR2(3)`	Indicates whether the partitioned table is a nested table (`YES`) or not (`NO`) See Also: the `*_NESTED_TABLES` view for the parent table name/column
`DEF_SEGMENT_CREATION`	`VARCHAR2(4)`	Specifies whether the default for segment creation was specified on the table level: `NO` - deferred was specified `YES` - immediate was specified `NONE` - a default for segment creation was not specified
`DEF_INDEXING`	`VARCHAR2(3)`	Indicates the indexing property specified for the table. Possible values: `ON` - `INDEXING` on was specified explicitly, or no indexing property was specified `OFF` - `INDEXING` off was specified.
`DEF_INMEMORY`	`VARCHAR2(8)`	Indicates whether the In-Memory Column Store (IM column store) is by default enabled (`ENABLED`), disabled (`DISABLED`), or not specified (`NONE`) for partitions in this table
`DEF_INMEMORY_PRIORITY`²	`VARCHAR2(8)`	Indicates the default priority for In-Memory Column Store (IM column store) population. Possible values: `LOW` `MEDIUM` `HIGH` `CRITICAL` `NONE` `NULL`
`DEF_INMEMORY_DISTRIBUTE`²	`VARCHAR2(15)`	Indicates how the IM column store is distributed by default for partitions of the table in an Oracle Real Application Clusters (Oracle RAC) environment: `AUTO` `BY ROWID RANGE` `BY PARTITION` `BY SUBPARTITION`
`DEF_INMEMORY_COMPRESSION`²	`VARCHAR2(17)`	Default compression level for the IM column store: `NO MEMCOMPRESS` `FOR DML` `FOR QUERY [ LOW \| HIGH ]` `FOR CAPACITY [ LOW \| HIGH ]` `NULL`
`DEF_INMEMORY_DUPLICATE`²	`VARCHAR2(13)`	Indicates the default duplicate setting for the IM column store in an Oracle RAC environment: `NO DUPLICATE` `DUPLICATE` `DUPLICATE ALL`