ALL_OBJECT_TABLES
describes the object tables accessible to the current user.
Related Views
DBA_OBJECT_TABLES
describes all object tables in the database.
USER_OBJECT_TABLES
describes the object tables owned by the current user. This view does not display the OWNER
column.
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:
|
|
|
|
Indicates whether the table has been backed up since the last modification ( |
|
|
|
Number of rows in the table |
|
|
|
Number of used blocks in the table |
|
|
|
Number of empty (never used) blocks in the table |
|
|
|
Average available free space in the table |
|
|
|
Number of chained rows in the table |
|
|
|
Average row length, including row overhead |
|
|
|
Average free space of all blocks on a freelist |
|
|
|
Number of blocks on the freelist |
|
|
|
Number of parallel execution processes 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 object ID (OID) is |
|
|
|
Owner of the type of the table |
|
|
|
Type of the table |
|
|
|
Indicates whether this is a temporary table ( |
|
|
|
Indicates whether the object table is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge ( |
|
|
|
Indicates whether the table is a nested table ( |
|
|
|
Buffer pool to be used for table blocks:
|
|
|
|
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 object 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 segment has been created ( |
|
|
|
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_REPAIR.SKIP_CORRUPT_BLOCKS
procedure
Hybrid Columnar Compression is a feature of the Enterprise Edition of Oracle Database. 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
.