|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Large Objects: Advanced Topics, 8 of 9
Oracle9i introduces support for LOB, VARRAY columns stored as LOBs, and BFILEs in partitioned index-organized tables. The behavior of LOB columns in these tables is similar to that of LOB columns in conventional (heap-organized) partitioned tables, except for the following few minor differences:
LOB columns are supported only in range partitioned index-organized tables.
In this section, we'll highlight the differences listed above for LOBs in partitioned index-organized tables with the Multimedia_Tab example described in Appendix B.
Assume that Multimedia-tab has been created as a range-partitioned index-organized table, as follows:
CREATE TABLE Multimedia_tab ( CLIP_ID INTEGER PRIMARY KEY, CLIP_DATE DATE, STORY CLOB, FLSUB NCLOB, PHOTO BFILE, FRAME BLOB, SOUND BLOB, ... ) ORGANIZATION INDEX TABLESPACE TBS_IDX OVERFLOW TABLESPACE TBS_OVF LOB (FRAME, S0UND) STORE AS (TABLESPACE TBS_LOB) PARTITION BY RANGE (CLIP_DATE) (PARTITION Jan_Multimedia_tab VALUES LESS THAN (01-FEB-2000) LOB (STORY) STORE AS (TABLESPACE TBS_LOB), PARTITION Feb_Multimedia_tab VALUES LESS THAN (01-MAR-2000) LOB (FLSUB) STORE AS (TABLESPACE TBS_LOB ENABLE STORAGE IN ROW) );
In the above example, the LOB columns FRAME and SOUND will be stored in the tablespace TBS_LOB across all the partitions.
The inheritance semantics for the rest of the LOB physical attributes are in line with LOBs in conventional tables.
Oracle9i SQL Reference, for a description of the lob_storage_clause in CREATE TABLE.