Get a specific table
get
/database/objects/tables/{owner},{table_name}
Describes a specific table in the database using DBA_TABLES or ALL_TABLES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
Request
Path Parameters
-
owner(required): string
Owner of the table.
-
table_name(required): string
Name of the table.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
All tables in the database.
Root Schema : DatabaseObjectsTablesItem
Type:
object
This object describes a relational table in the database.
Show Source
-
activity_tracking: string
Indicates whether Heat Map tracking is enabled on the table.
-
admit_null: string
Indicates whether the table admits null CON_ID data (YES) or not (NO).
-
avg_row_len: integer
Average length of a row in the table (in bytes).
-
avg_space: integer
Average amount of free space, in bytes, in a data block allocated to the table.
-
avg_space_freelist_blocks: integer
Average freespace of all blocks on a freelist.
-
backed_up: string
Indicates whether the table has been backed up since the last modification (Y) or not (N).
-
blocks: integer
Number of used data blocks in the table.
-
buffer_pool: string
Buffer pool for the table.
-
cache: string
Indicates whether the table is to be cached in the buffer cache (Y) or not (N).
-
cell_flash_cache: string
Cell flash cache hint to be used for table blocks.
-
cellmemory: string
The value for columnar compression in the storage cell flash cache.
-
chain_cnt: integer
Number of rows in the table that are chained from one data block to another, or which have migrated to a new block, requiring a link to preserve the old ROWID.
-
cluster_name: string
Name of the cluster, if any, to which the table belongs.
-
cluster_owner: string
Owner of the cluster, if any, to which the table belongs.
-
clustering: string
Indicates whether the table has the attribute clustering clause (YES) or not (NO).
-
compress_for: string
Default compression for what kind of operations:.
-
compression: string
Indicates whether table compression is enabled (ENABLED) or not (DISABLED); NULL for partitioned tables.
-
container_data: string
Indicates whether the table contains container-specific data.
-
container_map: string
Indicates whether the table is enabled for use with the container_map database property (YES) or not (NO).
-
container_map_object: string
Indicates whether the table is used as the value of the container_map database property (YES) or not (NO).
-
containers_default: string
Indicates whether the table is enabled for CONTAINERS() by default (YES) or not (NO).
-
data_link_dml_enabled: string
Indicates whether DML is permitted on the Data Link table (YES) or not (NO).
-
default_collation: string
Default collation for the table.
-
degree: string
Number of threads per instance for scanning the table, or DEFAULT.
-
dependencies: string
Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED).
-
dml_timestamp: string
Modification time, creation time, or both for Automatic Data Optimization.
-
dropped: string
Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO); NULL for partitioned tables. This view does not return the names of tables that have been dropped.
-
duplicated: string
Indicates whether this object is duplicated on this shard (Y) or not (N).
-
duration: string
Indicates the duration of a temporary table.
-
empty_blocks: integer
Number of empty (never used) data blocks in the table. This column is populated only if you collect statistics on the table using the DBMS_STATS package.
-
extended_data_link: string
Indicates whether the table is enabled for fetching an extended data link from the root (YES) or not (NO).
-
external: string
Indicates whether the table is an external table (YES) or not (NO).
-
flash_cache: string
Database Smart Flash Cache hint to be used for table blocks.
-
freelist_groups: integer
Number of freelist groups allocated to the segment; NULL for partitioned tables.
-
freelists: integer
Number of process freelists allocated to the segment; NULL for partitioned tables.
-
global_stats: string
GLOBAL_STATS will be YES if statistics are gathered or incrementally maintained, otherwise it will be NO.
-
has_identity: string
Indicates whether the table has an identity column (YES) or not (NO).
-
has_sensitive_column: string
Indicates whether the table has one or more sensitive columns (YES) or not (NO).
-
hybrid: string
Indicates whether the table is a hybrid partitioned table (YES) or not (NO). A hybrid partitioned table can contain a mixture of partitions stored in segments and partitions stored externally.
-
ini_trans: integer
Initial number of transactions; NULL for partitioned tables.
-
initial_extent: integer
Size of the initial extent (in bytes); NULL for partitioned tables.
-
inmemory: string
Indicates whether the In-Memory Column Store (IM column store) is enabled (ENABLED) or disabled (DISABLED) for this table
-
inmemory_compression: string
Indicates the compression level for the IM column store.
-
inmemory_distribute: string
Indicates how the IM column store is distributed in an Oracle Real Application Clusters (Oracle RAC) environment.
-
inmemory_duplicate: string
Indicates the duplicate setting for the IM column store in an Oracle RAC environment.
-
inmemory_priority: string
Indicates the priority for In-Memory Column Store (IM column store) population.
-
inmemory_service: string
Indicates how the IM column store is populated on various instances.
-
inmemory_service_name: string
Indicates the service name for the service on which the IM column store should be populated. This column has a value only when the corresponding INMEMORY_SERVICE is USER_DEFINED. In all other cases, this column is null.
-
instances: string
Number of instances across which the table is to be scanned, or DEFAULT.
-
iot_name: string
Name of the index-organized table, if any, to which the overflow or mapping table entry belongs. If the IOT_TYPE column is not NULL, then this column contains the base table name.
-
iot_type: string
If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. If the table is not an index-organized table, then IOT_TYPE is NULL.
-
last_analyzed: string
Date on which this table was most recently analyzed.
-
links: array
links
-
logging: string
Indicates whether or not changes to the table are logged; YES, NO, or NULL for partitioned tables.
-
logical_replication: string
Indicates whether the table is enabled for logical replication (ENABLED) or not (DISABLED). This setting is ignored if database-wide column data supplemental logging is enabled.
-
max_extents: integer
Maximum number of extents allowed in the segment; NULL for partitioned tables.
-
max_trans: integer
Maximum number of transactions; NULL for partitioned tables.
-
memoptimize_read: string
Indicates whether the table is enabled for Fast Key Based Access (ENABLED) or not (DISABLED).
-
min_extents: integer
Minimum number of extents allowed in the segment; NULL for partitioned tables.
-
monitoring: string
Indicates whether the table has the MONITORING attribute set (YES) or not (NO).
-
nested: string
Indicates whether the table is a nested table (YES) or not (NO).
-
next_extent: integer
Size of secondary extents (in bytes); NULL for partitioned tables.
-
num_freelist_blocks: integer
Number of blocks on the freelist.
-
num_rows: integer
Number of rows in the table.
-
owner: string
Owner of the table.
-
partitioned: string
Indicates whether the table is partitioned (YES) or not (NO).
-
pct_free: integer
Minimum percentage of free space in a block; NULL for partitioned tables.
-
pct_increase: integer
Percentage increase in extent size; NULL for partitioned tables.
-
pct_used: integer
Minimum percentage of used space in a block; NULL for partitioned tables.
-
read_only: string
Indicates whether the table segment is READ-ONLY or not.
-
result_cache: string
Result cache mode annotation for the table.
-
row_movement: string
Indicates whether partitioned row movement is enabled (ENABLED) or disabled (DISABLED).
-
sample_size: integer
Sample size used in analyzing this table.
-
secondary: string
Indicates whether the table is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N).
-
segment_created: string
Indicates whether the table segment is created.
-
sharded: string
Indicates whether this object is sharded (Y) or not (N).
-
skip_corrupt: string
Indicates whether Oracle Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED). To enable this feature, run the DBMS_REPAIR.SKIP_CORRUPT_BLOCKS procedure.
-
status: string
If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID).
-
table_lock: string
Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED).
-
table_name: string
Name of the table.
-
tablespace_name: string
Name of the tablespace containing the table; NULL for partitioned, temporary, and index-organized tables.
-
temporary: string
Indicates whether the table is temporary (Y) or not (N).
-
user_stats: string
Indicates whether statistics were entered directly by the user (YES) or not (NO).