GaussDB-MY_TABLESPACES
MY_TABLESPACES displays the description of tablespaces that store objects owned by users. By default, it is accessible to all users. This view exists in the PG_CATALOG and SYS schemas. The logical structure features of GaussDB are different from those of the ORA database.
| Name | Type | Description |
|---|---|---|
| tablespace_name | character varying(64) | Tablespace name. |
| block_size | numeric | Not supported. Set it to NULL. |
| initial_extent | numeric | Not supported. Set it to NULL. |
| next_extent | numeric | Not supported. Set it to NULL. |
| min_extents | numeric | Not supported. Set it to NULL. |
| max_extents | numeric | Not supported. Set it to NULL. |
| max_size | numeric | Not supported. Set it to NULL. |
| pct_increase | numeric | Not supported. Set it to NULL. |
| min_extlen | numeric | Not supported. Set it to NULL. |
| contents | character varying(9) | Not supported. Set it to NULL. |
| status | character varying(9) | Tablespace status. The default value is ONLINE. |
| logging | character varying(9) | Not supported. Set it to NULL. |
| force_logging | character varying(3) | Not supported. Set it to NULL. |
| extent_management | character varying(10) | Not supported. Set it to NULL. |
| allocation_type | character varying(9) | Not supported. Set it to NULL. |
| segment_space_management | character varying(6) | Not supported. Set it to NULL. |
| def_tab_compression | character varying(8) | Not supported. Set it to NULL. |
| retention | character varying(11) | Not supported. Set it to NULL. |
| bigfile | character varying(3) | Not supported. Set it to NULL. |
| predicate_evaluation | character varying(7) | Not supported. Set it to NULL. |
| encrypted | character varying(3) | Not supported. Set it to NULL. |
| compress_for | character varying(30) | Not supported. Set it to NULL. |
| def_inmemory | character varying(8) | Not supported. Set it to NULL. |
| def_inmemory_priority | character varying(8) | Not supported. Set it to NULL. |
| def_inmemory_distribute | character varying(15) | Not supported. Set it to NULL. |
| def_inmemory_compression | character varying(17) | Not supported. Set it to NULL. |
| def_inmemory_duplicate | character varying(13) | Not supported. Set it to NULL. |
| shared | character varying(12) | Not supported. Set it to NULL. |
| def_index_compression | character varying(8) | Not supported. Set it to NULL. |
| index_compress_for | character varying(13) | Not supported. Set it to NULL. |
| def_cellmemory | character varying(14) | Not supported. Set it to NULL. |
| def_inmemory_service | character varying(12) | Not supported. Set it to NULL. |
| def_inmemory_service_name | character varying(1000) | Not supported. Set it to NULL. |
| lost_write_protect | character varying(7) | Not supported. Set it to NULL. |
| chunk_tablespace | character varying(1) | Not supported. Set it to NULL. |
更多详情请参考GaussDB 文档中心:doc.hcs.huawei.com/db/zh-cn/ga…