Error: write_xml_to_clob: ...unable to extend lob segment ...Z00P_SEGNAME by ...
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
p_publish_04 ran run three times on our Prod server. Each time the log files (/abc01/scratch/) showed:
Error: write_xml_to_clob: ORA-01691: unable to extend lob segment UDM50.Z00P_SEGNAME by 8192 in
I've added two data files (2000 MB each) to the TS4D table where the z00p records reside, but it didn't help.
Should I add more data files to TS4D? Please advise.
Resolution:
The abc01 util a/17/11/2 showed that there were 1,977,152 z00's occupying 2.7 gig:
space (KB:) 2752512 344064 42 1006632960 8192
COUNT(*)
----------
1977152
The abc50 util a/17/11/2 for z00p shows:
BYTES/1024 BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT
---------- ---------- ---------- -------------- -----------
983040 122880 15 1006632960 8192
COUNT(*)
----------
742710
[After adding 12 gig to TS4D:]
Comparing the current abc50 util a/17/11/2 for z00p to the previous, we see that there are 1,551,878 z00p records (created/loaded by the most recent p_publish_04 run). The first loaded only 360,488 and the second, 742,710.
As noted previously, there are 1,977,152 z00's. With just a single publishing set in your abc01 tab_publish, the number of z00p's will be no more than 1,977,152.
Adding another 12 gig permitted all 1.9 million z00p's to be created/loaded.
- Article last edited: 10/8/2013