2.235 ALL_OBJECT_TABLES
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 theOWNER
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 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:
The |
|
|
|
Indicates whether the table has been dropped and is in the recycle bin ( This view does not return the names of tables that have been dropped. |
|
|
|
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:
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 |
|
|
|
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:
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 |
|
|
|
Indicates the duplicate setting for the IM column store in an Oracle RAC environment:
|
|
|
|
Indicates whether the table is an external table ( |
|
|
|
The value for columnar compression in the storage cell flash cache. Possible values:
|
|
|
|
Indicates whether the table is a hybrid partitioned table ( |
|
|
|
Indicates how the IM column store is populated on various instances. The possible values are:
|
|
|
|
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 |
|
|
|
Indicates whether the table is enabled for Fast Key Based Access ( |
|
|
|
For internal use only |
|
|
|
Indicates whether the table has one or more sensitive columns ( |
|
|
|
Indicates whether the table is enabled for logical replication ( |
Footnote 1 This column is intended for use with Oracle Exadata.
Footnote 2 This column is available starting with Oracle Database release 19c, version 19.1.
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_REPAIR.SKIP_CORRUPT_BLOCKS
procedure