Purpose
USER_TAB_SUBPARTITIONS displays, for each table subpartition owned by the current user, the subpartition name, the names of the table and partition to which it belongs, and its storage attributes.
Related views
ALL_TAB_SUBPARTITIONS
DBA_TAB_SUBPARTITIONS
Fields
| Field | 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(1024) | NO | The subpartition expression. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the subpartition expression. |
| 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 | At present, this field is not supported and is NULL by default. |
| PCT_USED | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| INI_TRANS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| MAX_TRANS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| MIN_EXTENT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| MAX_EXTENT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| MAX_SIZE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| PCT_INCREASE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| FREELISTS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| LOGGING | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| COMPRESSION | VARCHAR2(8) | NO | Indicates whether compression is enabled for the subpartition. |
| COMPRESS_FOR | VARCHAR2(12) | YES | The compression method. |
| NUM_ROWS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| BLOCKS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| EMPTY_BLOCKS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| AVG_SPACE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| CHAIN_CNT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| AVG_ROW_LEN | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this field is not supported and is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| INTERVAL | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |