[Home] [Help]
[Dependency Information]
TABLE: SYS.LOB$
Object Details
Object Name: | LOB$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 0 |
PCT Used: | 0 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_LOB2
|
NORMAL
|
UNIQUE
|
SYSTEM
|
LOBJ#
|
I_LOB1
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
OBJ#
INTCOL#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ# |
NUMBER |
|
Yes |
|
COL# |
NUMBER |
|
Yes |
|
INTCOL# |
NUMBER |
|
Yes |
|
LOBJ# |
NUMBER |
|
Yes |
|
PART# |
NUMBER |
|
Yes |
|
IND# |
NUMBER |
|
Yes |
|
TS# |
NUMBER |
|
Yes |
|
FILE# |
NUMBER |
|
Yes |
|
BLOCK# |
NUMBER |
|
Yes |
|
CHUNK |
NUMBER |
|
Yes |
|
PCTVERSION$ |
NUMBER |
|
Yes |
|
FLAGS |
NUMBER |
|
Yes |
|
PROPERTY |
NUMBER |
|
Yes |
|
RETENTION |
NUMBER |
|
Yes |
|
FREEPOOLS |
NUMBER |
|
Yes |
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
VARCHAR2 |
(255) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, COL#
, INTCOL#
, LOBJ#
, PART#
, IND#
, TS#
, FILE#
, BLOCK#
, CHUNK
, PCTVERSION$
, FLAGS
, PROPERTY
, RETENTION
, FREEPOOLS
, SPARE1
, SPARE2
, SPARE3
FROM SYS.LOB$;
Dependencies
[top of page]
SYS.LOB$ does not reference any database object
SYS.LOB$ is referenced by following:
-
CTXSYS
-
DRIREPZ
- show dependent code
-
SYS
-
ALL_LOBS
-
ALL_LOB_PARTITIONS
-
ALL_LOB_SUBPARTITIONS
-
ALL_PART_LOBS
-
ALL_VARRAYS
-
DBA_LOBS
-
DBA_LOB_PARTITIONS
-
DBA_LOB_SUBPARTITIONS
-
DBA_PART_LOBS
-
DBA_STREAMS_COLUMNS
-
DBA_VARRAYS
-
DBMSOBJG
- show dependent code
-
DBMS_FEATURE_DEFERRED_SEG_CRT
- show dependent code
-
DBMS_FEATURE_SECUREFILES_SYS
- show dependent code
-
DBMS_FEATURE_SECUREFILES_USR
- show dependent code
-
DBMS_FEATURE_SFCOMPRESS_SYS
- show dependent code
-
DBMS_FEATURE_SFCOMPRESS_USR
- show dependent code
-
DBMS_FEATURE_SFDEDUP_SYS
- show dependent code
-
DBMS_FEATURE_SFDEDUP_USR
- show dependent code
-
DBMS_FEATURE_SFENCRYPT_SYS
- show dependent code
-
DBMS_FEATURE_SFENCRYPT_USR
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_PLUGTS
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
EXU112DLOB
-
EXU81LBSP
-
EXU9LBCP
-
EXU9LBP
-
EXU9LOB
-
EXU9PLB
-
IMP_LOB_INFO
-
KU$_HTABLE_BYTES_ALLOC_VIEW
-
KU$_IOTABLE_BYTES_ALLOC_VIEW
-
KU$_IOTPART_BYTES_ALLOC_VIEW
-
KU$_LOBCOMPPART_VIEW
-
KU$_LOBFRAG_VIEW
-
KU$_LOB_VIEW
-
KU$_PIOTLOBFRAG_VIEW
-
KU$_SUBLOBFRAG_VIEW
-
LOADER_LOB_FLAGS
-
LOGSTDBY_SUPPORT_11LOB
-
PRVT_ILM
- show dependent code
-
STRADDLING_RS_OBJECTS
-
STRADDLING_TS_OBJECTS
-
SYS_OBJECTS
-
USER_LOBS
-
USER_LOB_PARTITIONS
-
USER_LOB_SUBPARTITIONS
-
USER_PART_LOBS
-
USER_VARRAYS
-
_DBA_STREAMS_UNSUPPORTED_11_1
-
_DBA_STREAMS_UNSUPPORTED_11_2
-
_DBA_STREAMS_UNSUPPORTED_12_1