ALL_TABLES describes the relational tables accessible to the current user. To gather statistics for this view, use the DBMS_STATS package.
Related Views
DBA_TABLES describes all relational tables in the database.
USER_TABLES describes the relational tables owned by the current user. This view does not display the OWNER column.
Note:
Columns marked with an asterisk (*) are populated only if you collect statistics on the table with the DBMS_STATS package.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the table |
|
|
|
|
Name of the table |
|
|
|
Name of the tablespace containing the table; NULL for partitioned, temporary, and index-organized tables |
|
|
|
|
Name of the cluster, if any, to which the table belongs |
|
|
|
|
Name of the index-organized table, if any, to which the overflow or mapping table entry belongs. If the |
|
|
|
|
If a previous |
|
|
|
|
Minimum percentage of free space in a block; NULL for partitioned tables |
|
|
|
|
Minimum percentage of used space in a block; NULL for partitioned tables |
|
|
|
|
Initial number of transactions; NULL for partitioned tables |
|
|
|
|
Maximum number of transactions; NULL for partitioned tables |
|
|
|
|
Size of the initial extent (in bytes); NULL for partitioned tables |
|
|
|
|
Size of secondary extents (in bytes); NULL for partitioned tables |
|
|
|
|
Minimum number of extents allowed in the segment; NULL for partitioned tables |
|
|
|
|
Maximum number of extents allowed in the segment; NULL for partitioned tables |
|
|
|
|
Percentage increase in extent size; NULL for partitioned tables |
|
|
|
|
Number of process freelists allocated to the segment; NULL for partitioned tables |
|
|
|
|
Number of freelist groups allocated to the segment; NULL for partitioned tables |
|
|
|
|
Indicates whether or not changes to the table are logged; NULL for partitioned tables:
|
|
|
|
|
Indicates whether the table has been backed up since the last modification ( |
|
|
|
|
Number of rows in the table |
|
|
|
|
Number of used data blocks in the table |
|
|
|
|
Number of empty (never used) data blocks in the table. This column is populated only if you collect statistics on the table using the |
|
|
|
|
Average amount of free space, in bytes, in a data block allocated to the table |
|
|
|
|
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 |
|
|
|
|
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, or |
|
|
|
|
Number of instances across which the table is to be scanned, or |
|
|
|
|
Indicates whether the table is to be cached in the buffer cache ( |
|
|
|
|
Indicates whether table locking is enabled ( |
|
|
|
|
Sample size used in analyzing this table |
|
|
|
|
Date on which this table was most recently analyzed |
|
|
|
|
Indicates whether the table is partitioned ( |
|
|
|
|
If the table is an index-organized table, then |
|
|
|
|
Indicates whether the table is temporary ( |
|
|
|
|
Indicates whether the table is a secondary object created by the |
|
|
|
|
Indicates whether the table is a nested table ( |
|
|
|
|
Buffer pool for the table;
|
|
|
|
|
Database Smart Flash Cache hint to be used for table blocks:
Solaris and Oracle Linux functionality only. |
|
|
|
|
Cell flash cache hint to be used for table blocks:
See Also: Oracle Exadata Storage Server Software documentation for more information |
|
|
|
|
Indicates whether partitioned row movement is enabled ( |
|
|
|
|
Indicates whether statistics were gathered for the table as a whole (global statistics) ( |
|
|
|
|
Indicates whether statistics were entered directly by the user ( |
|
|
|
|
Indicates the duration of a temporary table:
Null - Permanent table |
|
|
|
|
Indicates whether Oracle Database ignores blocks marked corrupt during table and index scans ( |
|
|
|
|
Indicates whether the table has the |
|
|
|
|
Owner of the cluster, if any, to which the table belongs |
|
|
|
|
Indicates whether row-level dependency tracking is enabled ( |
|
|
|
|
Indicates whether table compression is enabled ( |
|
|
|
|
Default compression for what kind of operations: |
|
|
|
|
Indicates whether the table has been dropped and is in the recycle bin ( |
|
|
|
|
Indicates whether the table IS READ-ONLY ( |
|
|
|
|
Indicates whether the table segment is created ( |
|
|
|
|
Result cache mode annotation for the table:
|
|
|
|
|
Indicates whether the table has the attribute clustering clause ( |
|
|
|
|
Indicates whether Heat Map tracking is enabled on the table |
|
|
|
|
Modification time, creation time, or both for Automatic Data Optimization |
|
|
|
|
Indicates whether the table has an identity column ( |
|
|
|
|
Indicates whether the table contains container-specific data. Possible values:
|
|
|
|
|
Indicates whether the In-Memory Column Store (IM column store) is enabled ( |
|
|
|
|
Indicates the priority for In-Memory Column Store (IM column store) population. Possible values:
|
|
|
|
|
Indicates how the IM column store is distributed in an Oracle Real Application Clusters (Oracle RAC) environment:
|
|
|
|
|
Indicates the compression level for the IM column store:
|
|
|
|
|
Indicates the duplicate setting for the IM column store in an Oracle RAC environment:
|
See Also:
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_STATS package
Hybrid Columnar Compression is a feature of the Enterprise Edition of Oracle Database that is dependent on the underlying storage system. See Oracle Database Concepts for more information..
This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).
This column has a value based on where the segments lie for a table. For example, if the table is partitioned and is enabled for the IM column store, the value is NULL for ALL_TABLES but non-NULL for ALL_TAB_PARTITIONS.