ALL_LOBS

ALL_LOBS displays the large objects (LOBs) contained in tables accessible to the user. LOBs include binary large objects (BLOBs) and character large objects (CLOBs). Binary files (BFILEs) are stored outside the database, so they are not displayed by this view or the related views.

Related Views

DBA_LOBS describes all LOBs in the database.

USER_LOBS describes the LOBs owned by the current user. This view does not display the OWNER column.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

Owner of the object containing the LOB

TABLE_NAME

VARCHAR2(30)

Name of the object containing the LOB

COLUMN_NAME

VARCHAR2(4000)

Name of the LOB column or attribute

SEGMENT_NAME

VARCHAR2(30)

Name of the LOB segment

INDEX_NAME

VARCHAR2(30)

Name of the LOB index

CHUNK

NUMBER

Size (in bytes) of the LOB chunk as a unit of allocation or manipulation

PCTVERSION

NUMBER

Maximum percentage of the LOB space used for versioning

RETENTION

NUMBER

Maximum time duration for versioning of the LOB space

FREEPOOLS

NUMBER

Number of freepools for this LOB segment

CACHE

VARCHAR2(10)

Whether and how the cluster is to be cached in the buffer cache (YES, NO, CACHEREADS)

LOGGING

VARCHAR2(7)

Indicates whether changes to the LOB are logged

IN_ROW

VARCHAR2(3)

Indicates whether some of the LOBs are stored inline with the base row

Related Views

DBA_OPERATOR_COMMENTS lists all comments for user-defined operators in the database.

USER_OPERATOR_COMMENTS lists all comments for user-defined operators owned by the current user.