Purpose
The USER_TAB_SUBPARTITIONS view displays, for each subpartition owned by the current user, the subpartition name, the names of the table and partition to which it belongs, and its storage properties.
Applicability
This view is only applicable to the Oracle mode of OceanBase Database.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| SUBPARTITION_NAME | VARCHAR2(128) | NO | The name of the subpartition. |
| HIGH_VALUE | VARCHAR2(32767) | NO | The subpartition expression. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the subpartition expression. |
| PARTITION_POSITION | NUMBER | NO | The position of the partition. |
| SUBPARTITION_POSITION | NUMBER | NO | The position of the subpartition within the partition. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace containing the subpartition. |
| 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(3) | NO | This column is currently not supported and defaults to NULL. |
| COMPRESSION | VARCHAR2(8) | NO | Indicates whether the subpartition is compressed. |
| COMPRESS_FOR | VARCHAR2(30) | NO | 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. |
| INTERVAL | VARCHAR2(3) | NO | This column is currently not supported and defaults to NO. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | This column is currently not supported and defaults to NULL. |
| INDEXING | VARCHAR2(3) | NO | This column defaults to NULL. |
| READ_ONLY | VARCHAR2(3) | NO | This column defaults to NULL. |
| 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. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | This column is compatible with Oracle but has no practical meaning and defaults to NULL. |
| INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | This column is compatible with Oracle but has no practical meaning and defaults to NULL. |
| CELLMEMORY | VARCHAR2(24) | 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. |
Related views
ALL_TAB_SUBPARTITIONS
DBA_TAB_SUBPARTITIONS