ALL_TABLES

ALL_TABLES describes all relational tables accessible to the user. To gather statistics for this view, use the SQL ANALYZE statement.

Related Views

• DBA_TABLES describes all relational tables in the database.

• USER_TABLES describes all 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 ANALYZE statement or the DBMS_STATS package.

  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 entry belongs. If IOT_TYPE column is not null, this column contains the base table name.
  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 the secondary extension 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 this segment; NULL for partitioned tables
  FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment; NULL for partitioned tables
  LOGGING	VARCHAR2(3)		Logging attribute; NULL for partitioned tables
  BACKED_UP	VARCHAR2(1)		Has table been backed up since last change
  NUM_ROWS*	NUMBER		Number of rows in the table
  BLOCKS*	NUMBER		Number of used data blocks in the table
  EMPTY_BLOCKS*	NUMBER		Number of empty (never used) data blocks in the table
  AVG_SPACE*	NUMBER		Average amount of free space, in bytes, in a data block allocated to the table
  CHAIN_CNT*	NUMBER		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
  AVG_ROW_LEN*	NUMBER		Average length of a row in the table in bytes
  AVG_SPACE_FREELIST _BLOCKS	NUMBER		The average freespace of all blocks on a freelist
  NUM_FREELIST_BLOCKS	NUMBER		The number of blocks on the freelist
  DEGREE	VARCHAR2(10)		The number of threads per instance for scanning the table
  INSTANCES	VARCHAR2(10)		The number of instances across which the table is to be scanned
  CACHE	VARCHAR2(5)		Whether the cluster is to be cached in the buffer cache (CACHE | NOCACHE)
  TABLE_LOCK	VARCHAR2(8)		Whether table locking is enabled or disabled
  SAMPLE_SIZE	NUMBER		Sample size used in analyzing this table
  LAST_ANALYZED	DATE		Date on which this table was most recently analyzed
  PARTITIONED	VARCHAR2(3)		Indicates whether this table is partitioned. Set to YES if it is partitioned.
  IOT_TYPE	VARCHAR2(12)		If this is an index organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. If this is not an index organized table, then IOT_TYPE is NULL.
  TEMPORARY	VARCHAR2(1)		Can the current session only see data that it place in this object itself?
  SECONDARY	VARCHAR2(1)		Whether the trigger is a secondary object created by the ODCIIndexCreate method of the Oracle9i Data Cartridge (Y |N)
  NESTED	VARCHAR2(3)		Is the table a nested table?
  BUFFER_POOL	VARCHAR2(7)		The default buffer pool for the object. NULL for partitioned tables
  ROW_MOVEMENT	VARCHAR2(8)		Whether partitioned row movement is enabled or disabled
  GLOBAL_STATS	VARCHAR2(3)		For partitioned tables, indicates whether statistics were collected for the table as a whole (YES) or were estimated from statistics on underlying partitions and subpartitions (NO)
  USER_STATS	VARCHAR2(3)		Were the statistics entered directly by the user?
  DURATION	VARCHAR2(15)		Indicates the duration of a temporary table: SYS$SESSION: the rows are preserved for the duration of the session SYS$TRANSACTION: the rows are deleted after COMMIT Null for a permanent table
  SKIP_CORRUPT	VARCHAR2(8)		Whether Oracle 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)		Whether the table has the MONITORING attribute set

  See Also: "DBA_TABLES" "USER_TABLES"