Skip Headers
SYS_OBJECTS maps object IDs to object types and segment data block addresses.
SYS_OBJECTS
OBJECT_TYPE
VARCHAR2(15)
Type of the object
OBJECT_TYPE_ID
NUMBER
Type ID of the object
SEGMENT_TYPE_ID
Type of segment: TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, CACHE
TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, CACHE
OBJECT_ID
Object identifier
HEADER_FILE
ID of the file containing the segment header
HEADER_BLOCK
ID of the block containing the segment header
TS_NUMBER
The tablespace number