| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
ALL_ALL_TABLES describes the object tables and relational tables accessible to the current user.
Related Views
DBA_ALL_TABLES describes all object tables and relational tables in the database.
USER_ALL_TABLES describes the object tables and relational tables owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the table | |
TABLE_NAME |
VARCHAR2(30) |
Name of the table | |
TABLESPACE_NAME |
VARCHAR2(30) |
Name of the tablespace containing the table; null for partitioned, temporary, and index-organized tables | |
CLUSTER_NAME |
VARCHAR2(30) |
Name of the cluster, if any, to which the table belongs | |
IOT_NAME |
VARCHAR2(30) |
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. |
|
STATUS |
VARCHAR2(8) |
If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID) |
|
PCT_FREE |
NUMBER |
Minimum percentage of free space in a block; null for partitioned tables | |
PCT_USED |
NUMBER |
Minimum percentage of used space in a block; null for partitioned tables | |
INI_TRANS |
NUMBER |
Initial number of transactions; null for partitioned tables | |
MAX_TRANS |
NUMBER |
Maximum number of transactions; null for partitioned tables | |
INITIAL_EXTENT |
NUMBER |
Size of the initial extent (in bytes); null for partitioned tables | |
NEXT_EXTENT |
NUMBER |
Size of secondary extents (in bytes); null for partitioned tables | |
MIN_EXTENTS |
NUMBER |
Minimum number of extents allowed in the segment; null for partitioned tables | |
MAX_EXTENTS |
NUMBER |
Maximum number of extents allowed in the segment; null for partitioned tables | |
PCT_INCREASE |
NUMBER |
Percentage increase in extent size; null for partitioned tables | |
FREELISTS |
NUMBER |
Number of process freelists allocated to the segment; null for partitioned tables | |
FREELIST_GROUPS |
NUMBER |
Number of freelist groups allocated to the segment | |
LOGGING |
VARCHAR2(3) |
Logging attribute | |
BACKED_UP |
VARCHAR2(1) |
Indicates whether the table has been backed up since the last modification (Y) or not (N) |
|
NUM_ROWS |
NUMBER |
Number of rows in the table | |
BLOCKS |
NUMBER |
Number of used blocks in the table | |
EMPTY_BLOCKS |
NUMBER |
Number of empty (never used) blocks in the table | |
AVG_SPACE |
NUMBER |
Average available free space in the table | |
CHAIN_CNT |
NUMBER |
Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid. This column is updated only after you analyze the table. | |
AVG_ROW_LEN |
NUMBER |
Average row length, including row overhead | |
AVG_SPACE_FREELIST_BLOCKS |
NUMBER |
Average freespace of all blocks on a freelist | |
NUM_FREELIST_BLOCKS |
NUMBER |
Number of blocks on the freelist | |
DEGREE |
VARCHAR2(10) |
Number of threads per instance for scanning the table | |
INSTANCES |
VARCHAR2(10) |
Number of instances across which the table is to be scanned | |
CACHE |
VARCHAR2(5) |
Indicates whether the table is to be cached in the buffer cache (Y) or not (N) |
|
TABLE_LOCK |
VARCHAR2(8) |
Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED) |
|
SAMPLE_SIZE |
NUMBER |
Sample size used in analyzing the table | |
LAST_ANALYZED |
DATE |
Date on which the table was most recently analyzed | |
PARTITIONED |
VARCHAR2(3) |
Indicates whether the table is partitioned (YES) or not (NO) |
|
IOT_TYPE |
VARCHAR2(12) |
If the table is an index-organized table, indicates whether an overflow segment has been specified (IOT_OVERFLOW) or not (NULL) |
|
OBJECT_ID_TYPE |
VARCHAR2(16) |
Indicates whether the object ID is USER-DEFINED or SYSTEM GENERATED |
|
TABLE_TYPE_OWNER |
VARCHAR2(30) |
If an object table, owner of the type from which the table is created | |
TABLE_TYPE |
VARCHAR2(30) |
If an object table, type of the table | |
TEMPORARY |
VARCHAR2(1) |
Indicates whether the table is temporary (Y) or not (N) |
|
SECONDARY |
VARCHAR2(1) |
Indicates whether the table is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge to contain the contents of a domain index (Y) or not (N) |
|
NESTED |
VARCHAR2(3) |
Indicates whether the table is a nested table (YES) or not (NO) |
|
BUFFER_POOL |
VARCHAR2(7) |
Buffer pool to be used for table blocks:
|
|
ROW_MOVEMENT |
VARCHAR2(8) |
If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED) |
|
GLOBAL_STATS |
VARCHAR2(3) |
For partitioned tables, indicates whether statistics were collected by analyzing the table as a whole (YES) or were estimated from statistics on underlying partitions and subpartitions (NO) |
|
USER_STATS |
VARCHAR2(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
|
DURATION |
VARCHAR2(15) |
Indicates the duration of a temporary table:
Null for a permanent table |
|
SKIP_CORRUPT |
VARCHAR2(8) |
Indicates whether the 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. |
|
MONITORING |
VARCHAR2(3) |
Indicates whether the table has the MONITORING attribute set (YES) or not (NO) |
|
CLUSTER_OWNER |
VARCHAR2(30) |
Owner of the cluster, if any, to which the table belongs | |
DEPENDENCIES |
VARCHAR2(8) |
Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED) |
|
COMPRESSION |
VARCHAR2(8) |
Indicates whether table compression is enabled (ENABLED) or not (DISABLED); null for partitioned tables |
|
DROPPED |
VARCHAR2(3) |
Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO); null for partitioned tables |
See Also:
