Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    p_manage_01: ORA-1653: unable to extend table

    1. Last updated
      12:53, 9 Dec 2015
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 14.2

    Description:
    The p_manage_01_e and e2 step failed. The errors are the following from the logs:

    p_manage_01_e.log:Commit point reached - logical SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued..
    p_manage_01_e2.log:Commit point reached - logical SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued..

    I checked the alert log and found.

    ORA-1653: unable to extend table CUN01.Z98 by 64000 in tablespace TS0_PROD_TAB.
    ORA-1653: unable to extend table CUN01.Z98 by 64000 in tablespace TS0_PROD_TAB.

    Looks like the ts0_prod_tab has to be extended. Unfortunately, I don't have OEM running at home, so I search around for the alter tablespace command. How do we restart? (hope not from the beginning).

    Resolution:
    In the case of the ORA-1653 error, the job doesn't cancel, it just halts. Once you add the file to the tablespace, the job will resume.

    Note: This is v14. It may be that this is different in later versions of Oracle / Aleph.

    • Article last edited: 10/8/2013