LOB Clause

Specify a Large Object

Syntax:

   LOB (lob_item,…) STORE AS (options)

   LOB (lob_item,…) STORE AS LOB_segname [(options)]

options:

   TABLESPACE tablespace
   {ENABLE|DISABLE} STORAGE IN ROW
   STORAGE storage_clause
   CHUNK int
   PCTVERSION int
   CACHE
   CACHE READS [[NO]LOGGING]
   NOCACHE [[NO]LOGGING]
   RETENTION
   FREEPOOLS int

Syntax - to modify a LOB:

   MODIFY LOB (lob_item,…) (storage_options)

storage_options:

   PCTVERSION int
   CACHE
   CACHE READS [LOGGING | NOLOGGING]
   NOCACHE [LOGGING | NOLOGGING]
   ALLOCATE EXTENT [( [DATAFILE filname] [SIZE int {K | M}] [INSTANCE int] )]
   DEALLOCATE UNUSED [KEEP int [K|M] ]
   STORAGE storage_clause

Related Oracle Commands:

MVIEW - ALTER MATERIALIZED VIEW
TABLE - CREATE TABLE
TABLE - ALTER TABLE