Purpose
This view displays the partition information of the partitions that the current user can access in partitioned tables.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the partitioned table. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the partitioned table. |
| PARTITIONING_TYPE | VARCHAR2(9) | NO | The partitioning method. Valid values include: |
| SUBPARTITIONING_TYPE | VARCHAR2(9) | NO | The subpartitioning method. Valid values include: |
| PARTITION_COUNT | NUMBER | NO | The number of partitions in the partitioned table. |
| DEF_SUBPARTITION_COUNT | NUMBER | NO | The number of subpartitions in a composite partitioned table. |
| PARTITIONING_KEY_COUNT | NUMBER | NO | The number of partitioning keys. |
| SUBPARTITIONING_KEY_COUNT | NUMBER | NO | The number of subpartitioning keys in a composite partitioned table. |
| STATUS | VARCHAR2(8) | NO | Not supported. The default value is NULL. |
| DEF_TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace to which the partitioned table belongs. |
| DEF_PCT_FREE | NUMBER | NO | Not supported. The default value is NULL. |
| DEF_PCT_USED | NUMBER | NO | Not supported. The default value is NULL. |
| DEF_INI_TRANS | NUMBER | NO | Not supported. The default value is NULL. |
| DEF_MAX_TRANS | NUMBER | NO | Not supported. The default value is NULL. |
| DEF_INITIAL_EXTENT | VARCHAR2(40) | NO | Not supported. The default value is NULL. |
| DEF_NEXT_EXTENT | VARCHAR2(40) | NO | Not supported. The default value is NULL. |
| DEF_MIN_EXTENT | VARCHAR2(40) | NO | Not supported. The default value is NULL. |
| MAX_EXTENT | VARCHAR2(40) | NO | Not supported. The default value is NULL. |
| DEF_MAX_SIZE | VARCHAR2(40) | NO | Not supported. The default value is NULL. |
| DEF_PCT_INCREASE | VARCHAR2(40) | NO | Not supported. The default value is NULL. |
| DEF_FREELISTS | NUMBER | NO | Not supported. The default value is NULL. |
| DEF_FREELIST_GROUPS | NUMBER | NO | Not supported. The default value is NULL. |
| DEF_LOGGING | VARCHAR2(7) | NO | Not supported. The default value is NULL. |
| DEF_COMPRESSION | VARCHAR2(8) | NO | Whether to enable compression. |
| DEF_COMPRESS_FOR | VARCHAR2(30) | NO | The compression method. |
| DEF_BUFFER_POOL | VARCHAR2(7) | NO | Not supported. The default value is NULL. |
| DEF_FLASH_CACHE | VARCHAR2(7) | NO | Not supported. The default value is NULL. |
| DEF_CELL_FLASH_CACHE | VARCHAR2(7) | NO | Not supported. The default value is NULL. |
| REF_PTN_CONSTRAINT_NAME | VARCHAR2(128) | NO | Not supported. The default value is NULL. |
| INTERVAL | VARCHAR2(1000) | NO | Not supported. The default value is NULL. |
| AUTOLIST | VARCHAR2(3) | NO | Indicates whether to automatically list-partition a local index. Valid values include: |
| INTERVAL_SUBPARTITION | VARCHAR2(1000) | NO | Not supported. The default value is NULL. |
| AUTOLIST_SUBPARTITION | VARCHAR2(3) | NO | Not supported. The default value is NULL. |
| IS_NESTED | VARCHAR2(3) | NO | Not supported. The default value is NULL. |
| DEF_SEGMENT_CREATED | VARCHAR2(4) | NO | Not supported. The default value is NULL. |
| DEF_INDEXING | VARCHAR2(3) | NO | The index attribute specified for the table. Valid values include: |
| DEF_INMEMORY | VARCHAR2(8) | NO | Compatible with Oracle. The value is NULL and has no practical meaning. |
| DEF_INMEMORY_PRIORITY | VARCHAR2(8) | NO | Compatible with Oracle. The value is NULL and has no practical meaning. |
| DEF_INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | Compatible with Oracle. The value is NULL and has no practical meaning. |
| DEF_INMEMORY_COMPRESSION | VARCHAR2(17) | NO | Compatible with Oracle. The value is NULL and has no practical meaning. |
| DEF_INMEMORY_DUPLICATE | VARCHAR2(13) | NO | Compatible with Oracle. The value is NULL and has no practical meaning. |
| DEF_READ_ONLY | VARCHAR2(3) | NO | Indicates whether the default setting for new partitions is read-only or read/write. Valid values include: |
| DEF_CELLMEMORY | VARCHAR2(24) | NO | Compatible with Oracle. The value is NULL and has no practical meaning. |
| DEF_INMEMORY_SERVICE | VARCHAR2(12) | NO | Compatible with Oracle. The value is NULL and has no practical meaning. |
| DEF_INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | Compatible with Oracle. The value is NULL and has no practical meaning. |
| AUTO | VARCHAR2(3) | NO | Indicates whether the table is automatically partitioned. Valid values include: |
References
DBA_PART_TABLES
USER_PART_TABLES