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 both PG_CATALOG and SYS schema. The logical structure features of GaussDB are different from those of the ORA database.

**Table 1** MY_TABLESPACES columns
Name	Type	Description
tablespace_name	character varying(64)	Tablespace name
block_size	numeric	Not supported. Its value is NULL.
initial_extent	numeric	Not supported. Its value is NULL.
next_extent	numeric	Not supported. Its value is NULL.
min_extents	numeric	Not supported. Its value is NULL.
max_extents	numeric	Not supported. Its value is NULL.
max_size	numeric	Not supported. Its value is NULL.
pct_increase	numeric	Not supported. Its value is NULL.
min_extlen	numeric	Not supported. Its value is NULL.
contents	character varying(9)	Not supported. Its value is NULL.
status	character varying(9)	Tablespace status. The default value is ONLINE.
logging	character varying(9)	Not supported. Its value is NULL.
force_logging	character varying(3)	Not supported. Its value is NULL.
extent_management	character varying(10)	Not supported. Its value is NULL.
allocation_type	character varying(9)	Not supported. Its value is NULL.
segment_space_management	character varying(6)	Not supported. Its value is NULL.
def_tab_compression	character varying(8)	Not supported. Its value is NULL.
retention	character varying(11)	Not supported. Its value is NULL.
bigfile	character varying(3)	Not supported. Its value is NULL.
predicate_evaluation	character varying(7)	Not supported. Its value is NULL.
encrypted	character varying(3)	Not supported. Its value is NULL.
compress_for	character varying(30)	Not supported. Its value is NULL.
def_inmemory	character varying(8)	Not supported. Its value is NULL.
def_inmemory_priority	character varying(8)	Not supported. Its value is NULL.
def_inmemory_distribute	character varying(15)	Not supported. Its value is NULL.
def_inmemory_compression	character varying(17)	Not supported. Its value is NULL.
def_inmemory_duplicate	character varying(13)	Not supported. Its value is NULL.
shared	character varying(12)	Not supported. Its value is NULL.
def_index_compression	character varying(8)	Not supported. Its value is NULL.
index_compress_for	character varying(13)	Not supported. Its value is NULL.
def_cellmemory	character varying(14)	Not supported. Its value is NULL.
def_inmemory_service	character varying(12)	Not supported. Its value is NULL.
def_inmemory_service_name	character varying(1000)	Not supported. Its value is NULL.
lost_write_protect	character varying(7)	Not supported. Its value is NULL.
chunk_tablespace	character varying(1)	Not supported. Its value is NULL.