| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
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(9) |
Type of the partitioning method:
|
|
SUBPARTITIONING_TYPE |
VARCHAR2(7) |
Type of the 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, or DEFAULT if no INITIAL value was specified |
|
DEF_NEXT_EXTENT |
VARCHAR2(40) |
Default value of NEXT (in Oracle blocks) to be used when adding a partition, or DEFAULT if no NEXT value was specified |
|
DEF_MIN_EXTENTS |
VARCHAR2(40) |
Default value of MINEXTENTS to be used when adding a partition, or DEFAULT if no MINEXTENTS value was specified |
|
DEF_MAX_EXTENTS |
VARCHAR2(40) |
Default value of MAXEXTENTS to be used when adding a partition, or DEFAULT if no MAXEXTENTS value was specified |
|
DEF_MAX_SIZE |
VARCHAR2(40) |
Default value of MAXSIZE to be used when adding a partition, or DEFAULT if no MAXSIZE value was specified |
|
DEF_PCT_INCREASE |
VARCHAR2(40) |
Default value of PCTINCREASE to be used when adding a partition, or DEFAULT if no PCTINCREASE value was 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:
|
|
DEF_COMPRESSION |
VARCHAR2(8) |
Default compression to be used when adding a partition:
|
|
DEF_BUFFER_POOL |
VARCHAR2(7) |
Default buffer pool to be used when adding a partition:
|
|
REF_PTN_CONSTRAINT_NAME |
VARCHAR2(30) |
Name of the partitioning referential constraint for reference-partitioned tables | |
INTERVAL |
VARCHAR2(1000) |
String of the interval value |
See Also:
