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.

**Table 1** MY_TABLESPACES columns
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.