Static Data Dictionary Views, 38 of 452

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 (BILEs) 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)

NOT NULL

Owner of the object containing the LOB

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the object containing the LOB

COLUMN_NAME

VARCHAR2(4000)

Name of the LOB column or attribute

SEGMENT_NAME

VARCHAR2(30)

NOT NULL

Name of the LOB segment

INDEX_NAME

VARCHAR2(30)

NOT NULL

Name of the LOB index

CHUNK

NUMBER

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

PCTVERSION

NUMBER

NOT NULL

Maximum percentage of the LOB space used for versioning

CACHE

VARCHAR2(3)

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

LOGGING

VARCHAR2(3)

Whether changes to the LOB are logged

IN_ROW

VARCHAR2(3)

Whether some of the LOBs are stored inline with the base row

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the object containing the LOB
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the object containing the LOB
`COLUMN_NAME`	`VARCHAR2(4000)`		Name of the LOB column or attribute
`SEGMENT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the LOB segment
`INDEX_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the LOB index
`CHUNK`	`NUMBER`		Size in bytes of the LOB chunk as a unit of allocation or manipulation
`PCTVERSION`	`NUMBER`	`NOT NULL`	Maximum percentage of the LOB space used for versioning
`CACHE`	`VARCHAR2(3)`		Whether and how the cluster is to be cached in the buffer cache (`CACHE`, `NOCACHE`, `CACHEREADS`)
`LOGGING`	`VARCHAR2(3)`		Whether changes to the LOB are logged
`IN_ROW`	`VARCHAR2(3)`		Whether some of the LOBs are stored inline with the base row