Static Data Dictionary Views, 325 of 452

SYS_OBJECTS

SYS_OBJECTS maps object IDs to object types and segment data block addresses.

Column	Datatype	Description
`OBJECT_TYPE`	`VARCHAR2(15)`	Type of the object
`OBJECT_TYPE_ID`	`NUMBER`	Type ID of the object
`SEGMENT_TYPE_ID`	`NUMBER`	Type of segment: `TABLE`, `CLUSTER`, `INDEX`, `ROLLBACK`, `DEFERRED` `ROLLBACK`, `TEMPORARY`, `CACHE`
`OBJECT_ID`	`NUMBER`	Object identifier
`HEADER_FILE`	`NUMBER`	ID of the file containing the segment header
`HEADER_BLOCK`	`NUMBER`	ID of the block containing the segment header
`TS_NUMBER`	`NUMBER`	The tablespace number