| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
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(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 | |
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. DEFAULT if INITIAL was not specified. |
|
DEF_NEXT_EXTENT |
VARCHAR2(40) |
Default value of NEXT (in Oracle blocks) 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) |
See Also:
