December 2002
Intermediate to advanced
928 pages
85h 29m
English
LOB_Storage_Clause
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.
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.
Indicates that the storage parameters to be applied immediately follow this keyword.
Specifies the name of a LOB segment, which can be used only when listing a single LOB item.