Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_ALL_TABLES

ALL_ALL_TABLES describes the object tables and relational tables accessible to the current user.

Related Views

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:
  • DEFAULT

  • KEEP

  • RECYCLE

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:

SYS$SESSION - Rows are preserved for the duration of the session

SYS$TRANSACTION - Rows are deleted after COMMIT

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