Purpose
Describes the subpartition names, table names, partitions to which the subpartitions belong, and storage attributes of all subpartitions owned by the current user.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | Table name |
| PARTITION_NAME | VARCHAR2(128) | NO | Partition name |
| SUBPARTITION_NAME | VARCHAR2(128) | NO | Subpartition name |
| HIGH_VALUE | VARCHAR2(32767) | NO | Subpartition expression |
| HIGH_VALUE_LENGTH | NUMBER | NO | Length of the subpartition expression |
| PARTITION_POSITION | NUMBER | NO | Position of the partition |
| SUBPARTITION_POSITION | NUMBER | NO | Position of the subpartition in the partition |
| TABLESPACE_NAME | VARCHAR2(30) | NO | Name of the tablespace that contains the subpartition |
| PCT_FREE | NUMBER | NO | This column is not supported. The default value is NULL. |
| PCT_USED | NUMBER | NO | This column is not supported. The default value is NULL. |
| INI_TRANS | NUMBER | NO | This column is not supported. The default value is NULL. |
| MAX_TRANS | NUMBER | NO | This column is not supported. The default value is NULL. |
| INITIAL_EXTENT | NUMBER | NO | This column is not supported. The default value is NULL. |
| NEXT_EXTENT | NUMBER | NO | This column is not supported. The default value is NULL. |
| MIN_EXTENT | NUMBER | NO | This column is not supported. The default value is NULL. |
| MAX_EXTENT | NUMBER | NO | This column is not supported. The default value is NULL. |
| MAX_SIZE | NUMBER | NO | This column is not supported. The default value is NULL. |
| PCT_INCREASE | NUMBER | NO | This column is not supported. The default value is NULL. |
| FREELISTS | NUMBER | NO | This column is not supported. The default value is NULL. |
| FREELIST_GROUPS | NUMBER | NO | This column is not supported. The default value is NULL. |
| LOGGING | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| COMPRESSION | VARCHAR2(8) | NO | Whether the subpartition is compressed |
| COMPRESS_FOR | VARCHAR2(30) | NO | Compression method |
| NUM_ROWS | NUMBER | NO | This column is not supported. The default value is NULL. |
| BLOCKS | NUMBER | NO | This column is not supported. The default value is NULL. |
| EMPTY_BLOCKS | NUMBER | NO | This column is not supported. The default value is NULL. |
| AVG_SPACE | NUMBER | NO | This column is not supported. The default value is NULL. |
| CHAIN_CNT | NUMBER | NO | This column is not supported. The default value is NULL. |
| AVG_ROW_LEN | NUMBER | NO | This column is not supported. The default value is NULL. |
| SAMPLE_SIZE | NUMBER | NO | This column is not supported. The default value is NULL. |
| LAST_ANALYZED | DATE | NO | This column is not supported. The default value is NULL. |
| BUFFER_POOL | VARCHAR2(7) | NO | This column is not supported. The default value is NULL. |
| FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported. The default value is NULL. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported. The default value is NULL. |
| GLOBAL_STATS | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| USER_STATS | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| INTERVAL | VARCHAR2(3) | NO | This field is not supported. The default value is NO. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| INDEXING | VARCHAR2(3) | NO | The default value is NULL |
| READ_ONLY | VARCHAR2(3) | NO | The default value is NULL |
| INMEMORY | VARCHAR2(8) | NO | Compatible with the Oracle field. The value is NULL and has no practical meaning. |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | Compatible with the Oracle field. The value is NULL and has no practical meaning. |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | Compatible with the Oracle field. The value is NULL and has no practical meaning. |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | Compatible with the Oracle field. The value is NULL and has no practical meaning. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | Compatible with the Oracle field. The value is NULL and has no practical meaning. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | Compatible with the Oracle field. The value is NULL and has no practical meaning. |
| INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | Compatible with the Oracle field. The value is NULL and has no practical meaning. |
| CELLMEMORY | VARCHAR2(24) | NO | Compatible with the Oracle field. The value is NULL and has no practical meaning. |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | The default value is NULL |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | The default value is NULL |
References
ALL_TAB_SUBPARTITIONS
DBA_TAB_SUBPARTITIONS