ADM_TABLES

ADM_TABLES displays all tables in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** ADM_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: The record is deleted. NO: The record 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 a 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 an external table. YES: The table is an external table. NO: The table is not an external table.
logging	character varying(3)	Specifies whether changes to a table are logged. 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)	Not supported. The value is NULL.
cell_flash_cache	character varying(7)	Not supported. The value is NULL.
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.
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.