|
|
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]
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 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