2.201 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(128)

NOT NULL

Owner of the table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the table

LOB_COL_NAME

VARCHAR2(4000)

Name of the LOB column

SUBPARTITION_NAME

VARCHAR2(132)

NOT NULL

Name of the subpartition

LOB_SEGMENT_NAME

VARCHAR2(132)

NOT NULL

Name of the LOB segment

TABLESPACE_NAME

VARCHAR2(30)

Tablespace name of the subpartition