Purpose
The USER_TAB_PARTITIONS view displays partition-level partitioning information, partition storage parameters, and partition statistics for all partitions owned by the current user.
Applicability
This view is only applicable to the Oracle mode of OceanBase Database.
Related views
DBA_TAB_PARTITIONSALL_TAB_PARTITIONS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the partitioned table. |
| COMPOSITE | VARCHAR2(3) | NO | Indicates whether the table is composite partitioned. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| SUBPARTITION_COUNT | NUMBER | YES | The number of subpartitions. |
| HIGH_VALUE | VARCHAR2(32767) | NO | The partition expression. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the partition expression. |
| PARTITION_POSITION | NUMBER | NO | The position of the partition. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace containing the partition. |
| PCT_FREE | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| PCT_USED | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| INI_TRANS | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| MAX_TRANS | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| INITIAL_EXTENT | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| NEXT_EXTENT | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| MIN_EXTENT | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| MAX_EXTENT | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| MAX_SIZE | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| PCT_INCREASE | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| FREELISTS | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| FREELIST_GROUPS | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| LOGGING | VARCHAR2(7) | NO | This column is currently not supported and defaults to NULL. |
| COMPRESSION | VARCHAR2(8) | NO | Indicates whether compression is enabled. |
| COMPRESS_FOR | VARCHAR2(30) | YES | The compression method. |
| NUM_ROWS | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| BLOCKS | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| EMPTY_BLOCKS | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| AVG_SPACE | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| CHAIN_CNT | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| AVG_ROW_LEN | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| SAMPLE_SIZE | NUMBER | NO | This column is currently not supported and defaults to NULL. |
| LAST_ANALYZED | DATE | NO | This column is currently not supported and defaults to NULL. |
| BUFFER_POOL | VARCHAR2(7) | NO | This column is currently not supported and defaults to NULL. |
| FLASH_CACHE | VARCHAR2(7) | NO | This column is currently not supported and defaults to NULL. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | This column is currently not supported and defaults to NULL. |
| GLOBAL_STATS | VARCHAR2(3) | NO | This column is currently not supported and defaults to NULL. |
| USER_STATS | VARCHAR2(3) | NO | This column is currently not supported and defaults to NULL. |
| IS_NESTED | VARCHAR2(3) | NO | This column is currently not supported and defaults to NULL. |
| PARENT_TABLE_PARTITION | VARCHAR2(128) | NO | This column is currently not supported and defaults to NULL. |
| INTERVAL | VARCHAR2(3) | NO | This column is currently not supported and defaults to NULL. |
| SEGMENT_CREATED | VARCHAR2(4) | NO | This column is currently not supported and defaults to NULL. |
| INDEXING | VARCHAR2(4) | NO | Indicates the indexing property. Valid values: |
| READ_ONLY | VARCHAR2(4) | NO | Indicates whether the subpartition is read-only. Valid values: |
| INMEMORY | VARCHAR2(8) | NO | This column is compatible with Oracle but has no practical meaning and defaults to NULL. |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | This column is compatible with Oracle but has no practical meaning and defaults to NULL. |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | This column is compatible with Oracle but has no practical meaning and defaults to NULL. |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | This column is compatible with Oracle but has no practical meaning and defaults to NULL. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | This column is compatible with Oracle but has no practical meaning and defaults to NULL. |
| CELLMEMORY | VARCHAR2(24) | NO | This column is currently not supported and defaults to NULL. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | This column is compatible with Oracle but has no practical meaning and defaults to NULL. |
| INMEMORY_SERVICE_NAME | VARCHAR2(100) | NO | This column is compatible with Oracle but has no practical meaning and defaults to NULL. |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | This column defaults to NULL. |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | This column defaults to NULL. |