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