Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_PART_TABLES

ALL_PART_TABLES displays the object-level partitioning information for the partitioned tables accessible to the current user.

Related Views

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:
  • RANGE

  • HASH

  • SYSTEM

  • LIST

SUBPARTITIONING_TYPE VARCHAR2(7)   Type of composite partitioning method:
  • NONE

  • HASH

  • SYSTEM

  • LIST

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)