Static Data Dictionary Views, 50 of 452

ALL_OBJECT_TABLES

ALL_OBJECT_TABLES describes all object tables accessible to the user.

Related views:

DBA_OBJECT_TABLES describes all object tables in the database.

USER_OBJECT_TABLES describes all object tables owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the table

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the table

TABLESPACE_NAME

VARCHAR2(30)

NOT NULL

Name of the tablespace containing the table

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

PCT_FREE

NUMBER

Minimum percentage of free space in a block

PCT_USED

NUMBER

Minimum percentage of used space in a block

INI_TRANS

NUMBER

Initial number of transactions

MAX_TRANS

NUMBER

Maximum number of transactions

INITIAL_EXTENT

NUMBER

Size in bytes of the initial extent

NEXT_EXTENT

NUMBER

Size in bytes of secondary extents

MIN_EXTENTS

NUMBER

Minimum number of extents allowed in the segment

MAX_EXTENTS

NUMBER

Maximum number of extents allowed in the segment

PCT_INCREASE

NUMBER

Percentage increase in extent size

FREELISTS

NUMBER

Number of process freelists allocated in this segment

FREELIST_GROUPS

NUMBER

Number of freelist groups allocated in this segment

LOGGING

VARCHAR2(3)

Logging attribute

BACKED_UP

VARCHAR2(1)

Whether the table has been backed up since last modification

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 chained rows in the table

AVG_ROW_LEN

NUMBER

Average row length, including row overhead

AVG_SPACE_FREELIST_BLOCKS

NUMBER

Average free space of all blocks on a freelist

NUM_FREELIST_BLOCKS

NUMBER

Number of blocks on the freelist

DEGREE

VARCHAR2(10)

Number of parallel execution processes per instance for scanning the table

INSTANCES

VARCHAR2(10)

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)

Whether the table is partitioned (YES | NO)

IOT_TYPE

VARCHAR2(12)

If index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL

OBJECT_ID_TYPE

VARCHAR2(16)

Whether the object ID (OID) is USER-DEFINED or SYSTEM-GENERATED

TABLE_TYPE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the type of the table if the table is a typed table

TABLE_TYPE

VARCHAR2(30)

NOT NULL

Type of the table if the table is a typed table

TEMPORARY

VARCHAR2(1)

Whether this is a temporary table

SECONDARY

VARCHAR2(1)

Whether the object table is a secondary object created by the ODCIIndexCreate method of the Oracle8i Data Cartridge (Y | N)

NESTED

VARCHAR2(3)

Whether the table a nested table

BUFFER_POOL

VARCHAR2(7)

Default buffer pool to be used for table blocks

ROW_MOVEMENT

VARCHAR2(8)

Whether partitioned row movement is ENABLED or DiSABLED

GLOBAL_STATS

VARCHAR2(3)

For partitioned object tables, 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)

Whether statistics were 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

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the table
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the table
`TABLESPACE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the tablespace containing the table
`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
`PCT_FREE`	`NUMBER`		Minimum percentage of free space in a block
`PCT_USED`	`NUMBER`		Minimum percentage of used space in a block
`INI_TRANS`	`NUMBER`		Initial number of transactions
`MAX_TRANS`	`NUMBER`		Maximum number of transactions
`INITIAL_EXTENT`	`NUMBER`		Size in bytes of the initial extent
`NEXT_EXTENT`	`NUMBER`		Size in bytes of secondary extents
`MIN_EXTENTS`	`NUMBER`		Minimum number of extents allowed in the segment
`MAX_EXTENTS`	`NUMBER`		Maximum number of extents allowed in the segment
`PCT_INCREASE`	`NUMBER`		Percentage increase in extent size
`FREELISTS`	`NUMBER`		Number of process freelists allocated in this segment
`FREELIST_GROUPS`	`NUMBER`		Number of freelist groups allocated in this segment
`LOGGING`	`VARCHAR2(3)`		Logging attribute
`BACKED_UP`	`VARCHAR2(1)`		Whether the table has been backed up since last modification
`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 chained rows in the table
`AVG_ROW_LEN`	`NUMBER`		Average row length, including row overhead
`AVG_SPACE_FREELIST_BLOCKS`	`NUMBER`		Average free space of all blocks on a freelist
`NUM_FREELIST_BLOCKS`	`NUMBER`		Number of blocks on the freelist
`DEGREE`	`VARCHAR2(10)`		Number of parallel execution processes per instance for scanning the table
`INSTANCES`	`VARCHAR2(10)`		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)`		Whether the table is partitioned (`YES` \| `NO`)
`IOT_TYPE`	`VARCHAR2(12)`		If index organized table, then `IOT_TYPE` is `IOT` or `IOT_OVERFLOW` else `NULL`
`OBJECT_ID_TYPE`	`VARCHAR2(16)`		Whether the object ID (OID) is `USER-DEFINED` or `SYSTEM-GENERATED`
`TABLE_TYPE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the type of the table if the table is a typed table
`TABLE_TYPE`	`VARCHAR2(30)`	`NOT NULL`	Type of the table if the table is a typed table
`TEMPORARY`	`VARCHAR2(1)`		Whether this is a temporary table
`SECONDARY`	`VARCHAR2(1)`		Whether the object table is a secondary object created by the ODCIIndexCreate method of the Oracle8i Data Cartridge (Y \| N)
`NESTED`	`VARCHAR2(3)`		Whether the table a nested table
`BUFFER_POOL`	`VARCHAR2(7)`		Default buffer pool to be used for table blocks
`ROW_MOVEMENT`	`VARCHAR2(8)`		Whether partitioned row movement is `ENABLED` or `DiSABLED`
`GLOBAL_STATS`	`VARCHAR2(3)`		For partitioned object tables, 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)`		Whether statistics were 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