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)
)
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@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9907339/viewspace-1048398/ ，如需转载，请注明出处，否则将追究法律责任。
