[Home] [Help]
[Dependency Information]
VIEW: SYS.SYS_OBJECTS
Object Details
Object Name: | SYS_OBJECTS |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJECT_TYPE |
VARCHAR2 |
(18) |
|
|
OBJECT_TYPE_ID |
NUMBER |
|
|
|
SEGMENT_TYPE_ID |
NUMBER |
|
|
|
OBJECT_ID |
NUMBER |
|
|
|
HEADER_FILE |
NUMBER |
|
|
|
HEADER_BLOCK |
NUMBER |
|
|
|
TS_NUMBER |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_TYPE
, OBJECT_TYPE_ID
, SEGMENT_TYPE_ID
, OBJECT_ID
, HEADER_FILE
, HEADER_BLOCK
, TS_NUMBER
FROM SYS.SYS_OBJECTS;
Dependencies
[top of page]
SYS.SYS_OBJECTS references the following:
-
SYS
-
CLU$
-
IND$
-
INDPART$
-
INDSUBPART$
-
LOB$
-
LOBFRAG$
-
TAB$
-
TABPART$
-
TABSUBPART$
SYS.SYS_OBJECTS is referenced by following:
-
SYS
-
SYS_DBA_SEGS
-
SYS_UNCOMPRESSED_SEGS_BASE
-
SYS_USER_SEGS