DBA_OBJECT_TABLES

DBA_OBJECT_TABLES describes all object tables in the database. Its columns are the same as those in ALL_OBJECT_TABLES.

Related Views

· ALL_OBJECT_TABLES describes the object tables accessible to the current user.

· USER_OBJECT_TABLES describes the 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)`		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; NULL for partitioned tables
`LOGGING`	`VARCHAR2(3)`		Indicates whether or not changes to the table are logged: · `YES` · `NO`
`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 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, or `DEFAULT`
`INSTANCES`	`VARCHAR2(10)`		Number of instances across which the table is to be scanned, or `DEFAULT`
`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 this table
`LAST_ANALYZED`	`DATE`		Date on which this 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, then `IOT_TYPE` is `IOT`, `IOT_OVERFLOW`, or `IOT_MAPPING`. If the table is not an index-organized table, then `IOT_TYPE` is NULL.
`OBJECT_ID_TYPE`	`VARCHAR2(16)`		Indicates whether the object ID (OID) is `USER-DEFINED` or `SYSTEM GENERATED`
`TABLE_TYPE_OWNER`	`VARCHAR2(30)`		Owner of the type of the table
`TABLE_TYPE`	`VARCHAR2(30)`		Type of the table
`TEMPORARY`	`VARCHAR2(1)`		Indicates whether this is a temporary table (`Y`) or not (`N`)
`SECONDARY`	`VARCHAR2(1)`		Indicates whether the object table is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (`Y`) or not (`N`)
`NESTED`	`VARCHAR2(3)`		Indicates whether the table is a nested table (`YES`) or not (`NO`)
`BUFFER_POOL`	`VARCHAR2(7)`		Default buffer pool to be used for table blocks: · `DEFAULT` · `KEEP` · `RECYCLE` · NULL
`ROW_MOVEMENT`	`VARCHAR2(8)`		Indicates whether partitioned row movement is enabled (`ENABLED`) or disabled (`DISABLED`)
`GLOBAL_STATS`	`VARCHAR2(3)`		For partitioned object 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)`		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 - Permanent table
`SKIP_CORRUPT`	`VARCHAR2(8)`		Indicates whether 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
`COMPRESS_FOR`	`VARCHAR2(18)`		Default compression for what kind of operations: · `DIRECT LOAD ONLY` · `FOR ALL OPERATIONS` · NULL
`DROPPED`	`VARCHAR2(3)`		Indicates whether the table has been dropped and is in the recycle bin (`YES`) or not (`NO`); NULL for partitioned tables

Note:

1. SELECT owner, table_name, status, table_type

FROM DBA_OBJECT_TABLES order by owner;

OWNER	TABLE_NAME	STATUS	TABLE_TYPE
MDSYS	SDO_GR_RDT_2	VALID	SDO_RASTER
SYS	SYSNTLCMA3vg9TlLgRAAUTyMV9w==	VALID	KUPC$_FILEINFO
SYS	KOTAD$	VALID	KOTAD
SYS	KOTMD$	VALID	KOTMD
SYS	KOTTBX$	VALID	KOTTBX
SYS	KOTADX$	VALID	KOTADX
SYS	KOTTD$	VALID	KOTTD
SYS	KOTTB$	VALID	KOTTB
SYS	SYSNTFqMXMbeuFOvgRAADuiMN8g==	VALID	KU$_LOGLINE1010
SYS	SYSNTFqMXMbesFOvgRAADuiMN8g==	VALID	KU$_LOGLINE1010
SYS	SYSNTFqMXMbeqFOvgRAADuiMN8g==	VALID	KUPC$_FILEINFO
SYS	SYSNTLCMA3vhBTlLgRAAUTyMV9w==	VALID	KU$_LOGLINE1010
SYS	SYSNTLCMA3vg/TlLgRAAUTyMV9w==	VALID	KU$_LOGLINE1010
SYS	WRI$_SQLSET_WORKSPACE_CPLANS	VALID	SQL_PLAN_ROW_TYPE
WMSYS	WM$EVENT_AUX_PARAMS_NT	VALID	WM$NV_PAIR_TYPE
WMSYS	WM$VERSIONED_TABLES_UNDO_CODE	VALID	WM$ED_UNDO_CODE_NODE_TYPE
XDB	SERVLET	VALID	XMLTYPE
XDB	xdb-log9_TAB	VALID	XMLTYPE
XDB	XDB$ALL_MODEL	VALID	XMLTYPE
XDB	XDB$ATTRGROUP_REF	VALID	XMLTYPE
XDB	XDB$SCHEMA	VALID	XMLTYPE
XDB	XDB$COMPLEX_TYPE	VALID	XMLTYPE
XDB	ftp-log14_TAB	VALID	XMLTYPE
XDB	http-log20_TAB	VALID	XMLTYPE
XDB	XDB$RESOURCE	VALID	XMLTYPE
XDB	XDB$NLOCKS	VALID	XDB$NLOCKS_T
XDB	XDB$CONFIG	VALID	XMLTYPE
XDB	XDB$H_LINK	VALID	XDB$LINK_T
XDB	XDB$SIMPLE_TYPE	VALID	XMLTYPE
XDB	XDB$CHOICE_MODEL	VALID	XMLTYPE
XDB	XDB$STATS	VALID	XMLTYPE
XDB	XDB$GROUP_REF	VALID	XMLTYPE
XDB	XDB$GROUP_DEF	VALID	XMLTYPE
XDB	XDB$ANY	VALID	XMLTYPE
XDB	XDB$ANYATTR	VALID	XMLTYPE
XDB	XDB$ATTRIBUTE	VALID	XMLTYPE
XDB	XDB$ELEMENT	VALID	XMLTYPE
XDB	XDB$SEQUENCE_MODEL	VALID	XMLTYPE
XDB	XDB$ATTRGROUP_DEF	VALID	XMLTYPE
XDB	XDB$ACL	VALID	XMLTYPE