Updated on 2024-06-03 GMT+08:00

MY_TABLES

MY_TABLES displays information about the tables owned by the current user. This view exists in the PG_CATALOG and SYS schemas.

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 an external table.

  • YES: The table is an external table.
  • NO: The table is not an external 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)

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. Set it to 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.