A.9 ALL_TABLES
ALL_TABLES
data dictionary for Oracle Database Gateway for DRDA.
The ALL_TABLES
view contains description of tables accessible to the user.
Column name | Description |
---|---|
|
Owner of the table |
|
Name of the table |
|
Name of the tablespace containing the table |
|
N/A |
|
Name of the index organized table |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
Number of process freelists allocated to this segment |
|
Number of freelist groups allocated to this segment |
|
Logging attribute |
|
N/A |
|
Number of rows in the table |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
Average length of a row in the table in bytes |
|
Average freespace of all blocks on a freelist |
|
Number of blocks on the freelist |
|
Number of threads per instance for scanning the table |
|
Number of instances across which the table is to be scanned |
|
Whether the cluster is to be cached in the buffer cache |
|
Whether the table locking is enabled or disabled |
|
Sample size used in analyzing this table |
|
Date on which this table was most recently analyzed |
|
Whether this table is partitioned |
|
Whether the table is an index-organized table |
|
Can the current session only see data that it placed in this object itself? |
|
N/A |
|
Whether the table is a nested table |
|
Default buffer pool for the object |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
Parent topic: Oracle DB2 Data Dictionary Views