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