ADM_TABLESPACES

ADM_TABLESPACES displays information about available tablespaces. By default, only the system administrator can access this view. Common users can access the view only after being authorized. 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** ADM_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)	Not supported 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.
plugged_in	character varying(3)	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.