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

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.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	Owner of the user-defined operator
  OPERATOR_NAME	VARCHAR2(30)	NOT NULL	Name of the user-defined operator
  COMMENTS	VARCHAR2(4000)		Comment for the user-defined operator

  See Also: "DBA_OPERATOR_COMMENTS" "USER_OPERATOR_COMMENTS"