Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

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