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

    Error: write_xml_to_clob: ORA-01691: unable to extend lob segment USR01.Z00P_SEGNAME

    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Problem Symptoms:
    Daemon ue_21 crashes with error message "Error: write_xml_to_clob: ORA-01691: unable to extend lob segment USR01.Z00P_SEGNAME"

    Cause:
    Tablespace problem

    Resolution:
    The problem occurs because of less tablespace. The error message says "unable to extend lob segment xxx00.Z00P_SEGNAME ...".

    In order to find out which tablespace is applied to the Z table (in this case Z00P) do util A/17/10/2:
    TAB z00p 4M 4M tspd

    Then check the tablespace using util o/14/1:

    TABLESPACE_WITHOUT_FREE_SPACE
    --------------------------------------------------------------------------------
    TSPD

    Add more tablespace to TSPD

    Category: System Management (500) - ALEPH

    Subject: Oracle (500) - ALEPH


    • Article last edited: 5/20/2014
    //doorbell.io feedback widged