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

Related Views:

DBA_LOBS              ALL_LOBS              USER_LOBS
DBA_LOB_PARTITIONS    ALL_LOB_PARTITIONS    USER_LOB_PARTITIONS
DBA_LOB_SUBPARTITIONS ALL_LOB_SUBPARTITIONS USER_LOB_SUBPARTITIONS


 
Copyright © 1999-2024 SS64.com
Some rights reserved