服务器报错
ORA-01694: max # extents (505) reached in lob segment NARROWAD.SYS_LOB0000003113C00005$$ partition SYS_LOB_P24
是因为Oracle表中的CLOB字段的扩展块设置有问题
分析服务器报错
ORA-01694: max # extents (505) reached in lob segment NARROWAD.SYS_LOB0000003113C00005$$ partition SYS_LOB_P24
检查:
select substr(segment_name,1,30) Segment_name,segment_type,partition_name,
substr(tablespace_name,1,20) Tablepace_name,extents,
Max_extents,bytes,blocks,INITIAL_EXTENT,NEXT_EXTENT
from dba_segments where segment_name like 'SYS_LOB%'
order by segment_name;
发现:
SYS_LOB0000003113C00005$$ LOB PARTITION SYS_LOB_P23 NARROWAD_BASIC_TABLE 505 505 60399616 7373 106496 106496
SYS_LOB0000003113C00005$$ LOB PARTITION SYS_LOB_P24 NARROWAD_BASIC_TABLE 505 505 60399616 7373 106496 106496
原因:
需要对CLOB字段单独进行设置
ALTER TABLE NAD_ADCustomer_URLLIST MODIFY LOB (URLS) (STORAGE(MAXEXTENTS 999999));