../E40402-16.epub /> ../E40402-16.mobi />

SYS_OBJECTS

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

Column Datatype NULL 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