René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Lob storage clause [Oracle SQL]

lob (lob-item-1 [, lob-item-n...] ) store as ( lob-parameters )
or 
lob (lob-item) store as
  lob-segment-name [ ( lob-parameters ) ] |
  ( lob-parameters )
The lob storage clause appears as part in the column properties clause or the table partition description clause.

Examples

Example 1

create table lob_storage_ex_1_tab (
  pk_column    number constraint lob_storage_ex_1_pk primary key,
  dt_column    date,
  lob_column_1 blob,
  lob_column_2 clob
)
lob (lob_column_1, lob_column_2) store as (tablespace users);

Example 2

create table lob_storage_ex_2_tab (
  pk_column    number constraint lob_storage_ex_2_pk primary key,
  dt_column    date,
  lob_column_1 blob,
  lob_column_2 clob
)
lob (lob_column_1) store as lob_segment_name_1 (tablespace users)
lob (lob_column_2) store as lob_segment_name_2 (tablespace ts_data);