分割槽表大物件

Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4

CREATE TABLE T_NEW (ID number, name blob ) PARTITION BY RANGE (id)

(PARTITION P1 VALUES LESS THAN (1000) tablespace TEST

lob (name) store as lob_name_p1

(tablespace test1),

PARTITION P2 VALUES LESS THAN (2000) tablespace system

lob (name) store as lob_name_p2

(tablespace test1),

PARTITION P3 VALUES LESS THAN (3000) tablespace users

lob (name) store as lob_name_p3

(tablespace test1),

PARTITION P4 VALUES LESS THAN (4000) tablespace sysaux

lob (name) store as lob_name_p4

(tablespace test1)

)

Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4

alter table t_new move partition p1 lob (name) store as ( tablespace test )

alter table t_new move partition p4 lob (name) store as ( tablespace test )

[@more@]