Partition Table with LOB Data
The code you created should look something like this:
tcreated a partitioned table containing LOB data.
CREATE TABLE ANIMAL_BEHAVIOR
STORAGE (INITIAL 100K NEXT 100K)
LOB (AV_CLIP) STORE AS (CHUNK 4096)
PARTITION BY RANGE(CLIP_DATE)
VALUES LESS THAN (TO_DATE('01-JUL-1951', 'DD-MON-YYYY'))
LOB (AV_CLIP) STORE AS (TABLESPACE OLDIES_CLIPS_TS),
VALUES LESS THAN (TO_DATE('01-JAN-1967', 'DD-MON-YYYY'))
LOB (AV_CLIP) store as (TABLESPACE PRE_66_CLIPS_TS),
VALUES LESS THAN (MAXVALUE)
LOB (AV_CLIP) store as (TABLESPACE POST_66_CLIPS_TS))
Here are suggested answers to your questions.
- What is the advantage of being able to partition an index-organized table?
A partitioned index-organized table allows a query that uses the primary key in its
clause to run faster because the uery can skip directly to the partition containing the range of data it is searching for.
- What is the purpose of separating the LOB portion of a partition to a separate tablespace?
Because LOB data tends to be large, it is advantageous to move it to a separate tablespace. Queries that do not involve the LOB data are more efficient.