| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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 |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
