OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the partitioned table |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the partitioned table |
PARTITIONING_TYPE |
VARCHAR2(7) |
|
Type of partitioning (RANGE | HASH ) |
SUBPARTITIONING_TYPE |
VARCHAR2(7) |
|
Type of subpartitioning (HASH | NONE ) |
PARTITION_COUNT |
NUMBER |
NOT NULL |
Number of partitions in this table |
DEF_SUBPARTITION_COUNT |
NUMBER |
NOT NULL |
For a composite-partitioned table, the default number of subpartitions, if specified |
PARTITIONING_KEY_COUNT |
NUMBER |
NOT NULL |
Number of columns in the partitioning key |
SUBPARTITIONING_KEY_COUNT |
NUMBER |
NOT NULL |
For a composite-partitioned table, the number of columns in the subpartitioning key |
DEF_TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Default tablespace to be used when adding a partition |
DEF_PCT_FREE |
NUMBER |
NOT NULL |
Default value of PCTFREE to be used when adding a partition |
DEF_PCT_USED |
NUMBER |
NOT NULL |
Default value of PCTUSED to be used when adding a partition |
DEF_INI_TRANS |
NUMBER |
NOT NULL |
Default value of INITRANS to be used when adding a partition |
DEF_MAX_TRANS |
NUMBER |
NOT NULL |
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 |
NOT NULL |
Default value of FREELISTS to be used when adding a partition |
DEF_FREELIST_GROUPS |
NUMBER |
NOT NULL |
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 |
DEF_BUFFER_POOL |
VARCHAR2(7) |
|
Default buffer pool to be used when adding a partition |