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

    Best way to export Aleph Oracle tables

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description

    What is the best way to export/import Aleph Oracle tables?

    Resolution

    There are three ways to export Aleph Oracle tables:

       1. The file-03 (export) and file-04 (import) Services

       2. util a/19 (export) and util a/20 (import) services

       3. The oracle_expdp_aleph_libs (export) and oracle_impdp_aleph_libs (import) -- using the Oracle Data Pump.

    file-03 works well for a single small table.   Except for very small libraries (under 200,000 records) the Oracle Data Pump is the best way to export/import data.  This is described in the following Knowledge Articles:

    Refreshing Test server data Using Oracle Data Pump

    Non-data-pump export/import of entire database

    Use Oracle Data Pump to transfer individual table

     

     


    • Article last edited: 6-Jun-2017