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

    Running oracle_expdp_table: Unable to open file "oracle_expdp_current_lib.sql"

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

    Problem Symptoms:
    The following messages appear in running oracle_expdp_table:

    SP2-0310: unable to open file "oracle_expdp_current_lib.sql"

    and later, these lines:

    UDE-31623: operation generated ORACLE error 31623
    ORA-31623: a job is not attached to this session via the specified handle
    ORA-06512: at "SYS.DBMS_DATAPUMP", line 2862
    ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052

    Cause:
    oracle_expdp_current_lib.sql proc can't be found unless the job is submitted from the $aleph_proc directory

    Resolution:
    Enter the command "cd $aleph_proc" before submitting the job.

    Additional Information

    The same error can occur for the oracle_impdp_table / oracle_expdp_current_lib.sql.

    Category: System Management (500)

    Subject: Oracle (500)


    • Article last edited: 10/8/2013