Use Oracle Data Pump to transfer individual table

• Article Type: General
• Product: Aleph
• Product Version: 20
• Relevant for Installation Type: Dedicated-Direct; Direct; Local;

Desired Outcome Goal:
Use the Oracle Data Pump to transfer an individual table from Production server to Test.

Procedure:
1. Since Java routines are used in the scripts, a new permission is must be granted (one time only) on the Production server:

s+ ALEPH_ADMIN
grant JAVA_ADMIN to aleph_admin WITH ADMIN OPTION;


2. Enter the following commands on the command line. As described in KB 16384-49361 ("Unable to open file "oracle_expdp_current_lib.sql"), the oracle_expdp_table and oracle_impdp_table procs *must* be run in the $aleph_proc directory. "XXX01" is the library for which the job is being run.

> cd $aleph_proc
> csh -f oracle_expdp_table XXX01,z00r > & $alephe_scratch/oracle_expdp_table.z00r.mmdd.log &

3. Copy the z00r export files from the Production XXX01 $data_files/dpdir directory to the Test server XXX01 $data_files/dpdir directory.

4. On the Test server (one time only):

s+ ALEPH_ADMIN
grant JAVA_ADMIN to aleph_admin WITH ADMIN OPTION;Do the following to load the table on the Test server:

5. Enter the following commands on the command line:

> cd $aleph_proc
> csh -f oracle_impdp_table XXX01,z00r > & $alephe_scratch/oracle_impdp_table.z00r.mmdd.log &