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

    p_manage_01: z98_id ... unable to extend temp segment in tablespace TS3X

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

    The p_manage_01 log has these messages:.
    Error : Only 0 indexes out of 1 for table z98 were created.
    Error : index list for index creation was 'z98_id'.
    Please check logs .../abc01/scratch/create_ora_tables_z98_id*.log.
    And the create_ora_tables_z98_id.log contains these error messages:.
    ... CREATE UNIQUE INDEX ABC01.Z98_ID ON ABC01.Z98 (Z98_REC_KEY ASC) * ERROR at line 1:.
    ORA-01652: unable to extend temp segment by 2560 in tablespace TS3X. Why does this happen?

    This is at the very end of the job.
    Since the Z98 data has loaded just fine, you can add a file to TS3X and then run UTIL-A-17-2 to build the z98_id.
    All should be OK; no need to re-run anything else..

    • Article last edited: 10/8/2013