Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph
    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Running oracle_expdp_table: Unable to open file "oracle_expdp_current_lib.sql"

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Running indexing p_manage_01 as a Direct hosted customer
      • Running other batch jobs while running indexing jobs
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 21
      2. contype:kba
      3. Oracle (500)
      4. Prod:Aleph
      5. System Management (500)
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved