Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    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
    //doorbell.io feedback widged