Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
ALL_PART_TABLES
displays the object-level partitioning information for the partitioned tables accessible to the current user.
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(7) |
Type of partitioning method:
| |
SUBPARTITIONING_TYPE |
VARCHAR2(7) |
Type of composite partitioning method:
| |
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 | |
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 ) |