How to export Oracle tables for particular library

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 20, 21, 22, 23

Desired Outcome Goal:
Export of all the Oracle tables for a particular library

Procedure:
1. Run util a/19 (Export Library) the library. This utility uses the oracle_exp_aleph_current_library procedure, which does not use the Oracle Data Pump.

2. Use the Oracle Data Pump (much faster) -- as described in KB 16384-12817 ("Refreshing Test server data Using Oracle Data Pump"). This does *all* of the libraries. The oracle_expdp_current_library proc could be run to export one individual library using the Data Pump.

Article last edited: 09-Feb-2016