Oracle in a Nutshell

Name

LOB_Storage_Clause

Synopsis

LOB 
{(lob_item[,lob_item...]) STORE AS
 (LOB_Parameter_Clause)
|(lob_item) STORE AS [(lob_segname)]
 (LOB_Parameter_Clause)
}

Specifies how LOB data segments are to be stored in a table, partition, or subpartition.

Keywords

LOB

Specifies that LOB storage parameters are provided for the listed LOB items. Any unlisted LOB item will use the same storage parameters as the table, partition, or subpartition. Note that Oracle automatically creates a system-managed index for each LOB item listed with this keyword.

STORE AS

Indicates that the storage parameters to be applied immediately follow this keyword.

STORE AS lob_segname

Specifies the name of a LOB segment, which can be used only when listing a single LOB item.