• 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