ALL_LOB_TEMPLATES

ALL_LOB_TEMPLATES describes the LOB subpartition templates accessible to the current user.

Related Views

• DBA_LOB_TEMPLATES describes all LOB subpartition templates in the database.
• USER_LOB_TEMPLATES describes the LOB subpartition templates owned by the current user. This view does not display the USER_NAME column.

  Column	Datatype	NULL	Description
  USER_NAME	VARCHAR2(30)	NOT NULL	Owner of the table
  TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the table
  LOB_COL_NAME	VARCHAR2(4000)		Name of the LOB column
  SUBPARTITION_NAME	VARCHAR2(34)	NOT NULL	Name of the subpartition
  LOB_SEGMENT_NAME	VARCHAR2(34)	NOT NULL	Name of the LOB segment
  TABLESPACE_NAME	VARCHAR2(30)		Tablespace name of the subpartition

  See Also: "DBA_LOB_TEMPLATES" "USER_LOB_TEMPLATES"