MY_TABLES

MY_TABLES displays information about the tables owned by the current user. This view exists in both PG_CATALOG and SYS schemas. For details about the columns, see Table 1.

**Table 1** MY_TABLES columns
Name	Type	Description
owner	character varying(64)	Table owner.
table_name	character varying(64)	Table name.
tablespace_name	character varying(64)	Tablespace name of the table.
dropped	character varying	Specifies whether the current table is deleted. YES: It is deleted. NO: It is not deleted.
num_rows	numeric	Estimated number of rows in the table.
status	character varying(8)	Specifies whether the current table is valid. VALID: The current table is valid. UNUSABLE: The current table is unavailable.
sample_size	numeric	Number of samples used for analyzing the table.
temporary	character(1)	Specifies whether the table is a temporary table. Y: The table is a temporary table. N: The table is not a temporary table.
pct_free	numeric	Minimum percentage of free space in a block.
ini_trans	numeric	Initial number of transactions.
max_trans	numeric	Maximum number of transactions.
avg_row_len	integer	Average number of bytes in each row.
partitioned	character varying(3)	Specifies whether a table is a partitioned table. YES: The table is a partitioned table. NO: The table is not a partitioned table.
last_analyzed	timestamp with time zone	Last time when the table was analyzed. Database restart is not supported. Otherwise, data loss will occur.
row_movement	character varying(8)	Specifies whether to allow partition row movement. ENABLED: The partition row movement is allowed. DISABLED: The partition row movement is not allowed.
compression	character varying(8)	Specifies whether to enable a table compression. ENABLED: A table compression is enabled. DISABLED: A table compression is disabled.
duration	character varying(15)	Time elapsed when a temporary table is processed. NULL: The table is not a temporary table. sys$session: The table is a temporary session table. sys$transaction: The table is a temporary transaction table.
logical_replication	character varying(8)	Specifies whether logical replication is enabled for a table. ENABLED: Logical replication is enabled. DISABLED: Logical replication is disabled.
external	character varying(3)	Specifies whether the table is a foreign table. YES: The table is a foreign table. NO: The table is not a foreign table.
logging	character varying(3)	Specifies whether to record logs for table changes. YES: Logs are recorded for table changes. NO: Logs are not recorded for table changes.
default_collation	character varying(100)	Default collation of a table.
degree	character varying(10)	Number of instances in a scanned table.
table_lock	character varying(8)	Specifies whether to enable a table lock. ENABLED: The table lock is enabled. DISABLED: The table lock is disabled.
nested	character varying(3)	Specifies whether a table is a nested table. YES: The table is a nested table. NO: The table is not a nested table.
buffer_pool	character varying(7)	Default buffer pool of a table.
flash_cache	character varying(7)	Smart flash cache hint in database for a table block.
cell_flash_cache	character varying(7)	Cell flash cache hint for a table block.
skip_corrupt	character varying(8)	Specifies whether to skip corrupted blocks during table scanning. ENABLED: The corrupted block is skipped. DISABLED: The corrupted block is not skipped.
has_identity	character varying(3)	Specifies whether a table has an identifier column. YES: There is an identifier column. NO: There is no identifier column.
inmemory	character varying(8)	Specifies whether to enable memory column store. ENABLED: Memory column store is enabled. DISABLED: Memory column store is disabled.
segment_created	character varying(3)	Specifies whether a table segment has been created. YES: The table segment has been created. NO: The table segment is not created.
monitoring	character varying(3)	Specifies whether to monitor the modification of a table. YES: The modification of the table is monitored. NO: The modification of the table is not monitored.
cluster_name	character varying(128)	Not supported. The value is NULL.
iot_name	character varying(128)	Not supported. The value is NULL.
pct_used	numeric	Not supported. The value is NULL.
initial_extent	numeric	Not supported. The value is NULL.
next_extent	numeric	Not supported. The value is NULL.
min_extents	numeric	Not supported. The value is NULL.
max_extents	numeric	Not supported. The value is NULL.
pct_increase	numeric	Not supported. The value is NULL.
freelists	numeric	Not supported. The value is NULL.
freelist_groups	numeric	Not supported. The value is NULL.
backed_up	character varying(1)	Not supported. The value is NULL.
blocks	numeric	Not supported. The value is NULL.
empty_blocks	numeric	Not supported. The value is NULL.
avg_space	numeric	Not supported. The value is NULL.
chain_cnt	numeric	Not supported. The value is NULL.
avg_space_freelist_blocks	numeric	Not supported. The value is NULL.
num_freelist_blocks	numeric	Not supported. The value is NULL.
instances	character varying(10)	Not supported. The value is NULL.
cache	character varying(5)	Not supported. The value is NULL.
iot_type	character varying(12)	Not supported. The value is NULL.
secondary	character varying(1)	Not supported. The value is NULL.
global_stats	character varying(3)	Not supported. The value is NULL.
user_stats	character varying(3)	Not supported. The value is NULL.
cluster_owner	character varying(30)	Not supported. The value is NULL.
dependencies	character varying(8)	Not supported. The value is NULL.
compression_for	character varying(30)	Not supported. The value is NULL.
read_only	character varying(3)	Not supported. The value is NULL.
result_cache	character varying(7)	Not supported. The value is NULL.
clustering	character varying(3)	Not supported. The value is NULL.
activity_tracking	character varying(23)	Not supported. The value is NULL.
dml_timestamp	character varying(25)	Not supported. The value is NULL.
container_data	character varying(3)	Not supported. The value is NULL.
inmemory_priority	character varying(8)	Not supported. The value is NULL.
inmemory_distribute	character varying(15)	Not supported. The value is NULL.
inmemory_compression	character varying(17)	Not supported. The value is NULL.
inmemory_duplicate	character varying(13)	Not supported. The value is NULL.
duplicated	character varying(1)	Not supported. The value is NULL.
sharded	character varying(1)	Not supported. The value is NULL.
hybrid	character varying(3)	Not supported. The value is NULL.
cellmemory	character varying(24)	Not supported. The value is NULL.
containers_default	character varying(3)	Not supported. The value is NULL.
container_map	character varying(3)	Not supported. The value is NULL.
extended_data_link	character varying(3)	Not supported. The value is NULL.
extended_data_link_map	character varying(3)	Not supported. The value is NULL.
inmemory_service	character varying(12)	Not supported. The value is NULL.
inmemory_service_name	character varying(1000)	Not supported. The value is NULL.
container_map_object	character varying(3)	Not supported. The value is NULL.
memoptimize_read	character varying(8)	Not supported. The value is NULL.
memoptimize_write	character varying(8)	Not supported. The value is NULL.
has_sensitive_column	character varying(3)	Not supported. The value is NULL.
admit_null	character varying(3)	Not supported. The value is NULL.
data_link_dml_enabled	character varying(3)	Not supported. The value is NULL.
object_id_type	character varying(16)	Not supported. The value is NULL.
table_type_owner	character varying(128)	Not supported. The value is NULL.
table_type	character varying(128)	Not supported. The value is NULL.
compress_for	character varying(30)	Not supported. The value is NULL.