SYS_OBJECTS

6.247 SYS_OBJECTS

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

Column	Datatype	Description
`OBJECT_TYPE`	`VARCHAR2(18)`	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