1.建表时如何制定lob表空间?
lob(oper_field) store as (tablespace salary_lob)
2.如何进行数据分区?
partition by range(create_time) interval(numtoyminterval(1, 'YEAR'))
(
partiton log4cms_part01 values less than(to_date('2022-01-01', 'yyyy-mm-dd'))
) tablespace salary_data;
3.如何移动lob字段到lob表空间?
alter table salary.act_evt_log move tablespace salary_lob lob(DATA_) store as(tablespace salary_lob);