Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    p_publish_04: ORA-01691: unable to extend lob segment

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

    Description:
    Running p_publish_04 we get the following error in publish_04.xml_err.n.n log files:
    Error: write_xml_to_clob: ORA-01691: unable to extend lob segment ABC50.Z00P_SEGNAME by 16384

    What is the recommended settings for ABC50 file_list for Z00P?

    util o/14/1

    TABLESPACE_WITHOUT_FREE_SPACE
    ------------------------------
    TS4D
    ******************************************************

    abc50 file_list:

    Z00P is using TS4D

    TAB z00p 4M 1M TS4D
    IND z00p_id 100K 100K TS3X
    IND z00p_id1 100K 100K TS3X
    IND z00p_id2 100K 100K TS3X
    IND z00p_id3 100K 100K TS3X
    IND z00p_id4 100K 100K TS3X
    SEQ last_publish_seq

    ***********************************************************
    abc50
    util a/17/11/2 for z00p shows:

    Enter Table/Index Name: z00p
    TABLE_NAME = Z00P
    check = ABC50
    active_library = ABC50

    BYTES/1024 BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT
    ---------- ---------- ---------- -------------- -----------
    262144 32768 2 4194304 134217728
    Elapsed: 00:00:00.33

    COUNT(*)
    ----------
    1157547

    Resolution:
    DBA added 4GB extend-able to 8GB for ts3d_13.dbf
    We still ran out of space.

    DBA added (two) 8g datafiles each extend-able to 16g and that was enough space.

    We don't know why TS3D needed so much space.

    Summary:
    Aleph had 24 GB (2GB x12) initially
    DBA added 4GB extend-able to 8GB (ran out of space) ts3d_14.dbf
    added 8GB extend-able to 16g ts3d_15.dbf
    added 8GB extend-able to 16g ts3d_16.dbf

    total: 64GB

    Note: DBA did not use util o/13/3
    Aleph util o/13/1 does not show ts3d_14.dbf, ts3d_15.dbf, ts3d_16.dbf since he added them from oracle backend.
    He wanted to make the datafiles extend-able - grow as needed

    Growing TS3D to 64GB allowed Publish_04 to finish.


    • Article last edited: 10/8/2013