| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01  | 
  | 
  | 
View PDF | 
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: