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. How to speed up legacy Oracle import (using utility imp)

    How to speed up legacy Oracle import (using utility imp)

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description:
    2. Resolution:
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01, 20, 21, 22, 23

    Description:


    How to speed up legacy Oracle import (using utility imp)
     

    Resolution:

    1. Modify the parameters COMMIT und BUFFER in line 27 of the script $aleph_proc/oracle_imp_current_lib_a as follows:

    from:

    aleph_imp FILE=$TMPDIR/imp_pipe.$$ FULL=Y INDEXES=N IGNORE=Y COMMIT=Y BUFFER=5120000

    to:

    aleph_imp FILE=$TMPDIR/imp_pipe.$$ FULL=Y INDEXES=N IGNORE=Y COMMIT=N BUFFER=51200000


    2. Start the import by executing the script $aleph_proc/oracle_imp_aleph_libs.

    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to specify today's date (or date + n days) in job_list
      • How to split VIDEO's into a separate Collection
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. 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