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 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:

  • UNKNOWN - Not specified

    See Also: the *_TABLES view

  • RANGE

  • HASH

  • SYSTEM

  • LIST

  • REFERENCE
SUBPARTITIONING_TYPE VARCHAR2(7)   Type of the composite partitioning method:

  • NONE - Not subpartitioned

    See Also: the *_TABLES view

  • 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 - 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(18)   Default compression for what kind of operations to be used when adding a partition:

  • DIRECT LOAD ONLY

  • FOR ALL OPERATIONS

  • UNKNOWN

  • NULL
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

See Also: