DBA Data[Home] [Help] [Dependency Information]

TABLE: SYSTEM.DEF$_LOB

Object Details
Object Name: DEF$_LOB
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Storage for LOB parameters to deferred RPCs

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: DEF$_LOB_PRIMARY
  1. ColumnID
Indexes
Index Type Uniqueness Tablespace Column
DEF$_LOB_PRIMARY NORMAL UNIQUE TablespaceSYSTEM ColumnID
SYS_IL0000002581C00003$$ LOB UNIQUE TablespaceSYSTEM
SYS_IL0000002581C00004$$ LOB UNIQUE TablespaceSYSTEM
SYS_IL0000002581C00005$$ LOB UNIQUE TablespaceSYSTEM
DEF$_LOB_N1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnENQ_TID
Columns
Name Datatype Length Mandatory Comments
ID RAW (16) Yes Identifier of LOB parameter
ENQ_TID VARCHAR2 (22)
Transaction identifier for deferred RPC with this LOB parameter
BLOB_COL BLOB (4000)
Binary LOB parameter
CLOB_COL CLOB (4000)
Character LOB parameter
NCLOB_COL NCLOB (4000)
National Character LOB parameter
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      ENQ_TID
,      BLOB_COL
,      CLOB_COL
,      NCLOB_COL
FROM SYSTEM.DEF$_LOB;

Dependencies

[top of page]

SYSTEM.DEF$_LOB does not reference any database object

SYSTEM.DEF$_LOB is referenced by following:

SchemaSYS
Package BodyDBMS_DEFER_SYS_DEFINER - show dependent code
SynonymDEF$_LOB