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