ALL_LOBS

ALL_LOBS displays the large objects (LOBs) contained in tables accessible to the current 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