Script to export customer libraries (Oracle Data Pump)

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

Article Type: General
Product: Aleph
Product Version: 22

Question

Is it possible to create a script to export only customer libraries with Oracle Data Pump?

Answer

Yes.

1. Use existing scripts (e.g. $aleph_proc/oracle_expdp_aleph_libs) as an example.

2. Create a new customer script (e.g. $aleph_proc/oracle_expdp_cus_libs). Details see in additional information

$aleph_proc/oracle_expdp_cus_libs

Additional Information

Example of $aleph_proc/oracle_expdp_cus_libs
#!/bin/csh -f
source $aleph_proc/def_local_env

setenv CUS_LIBS "xxx01 xxx10 xxx11 xxx50 xxx60"

foreach lib ($CUS_LIBS)
start_proc00 $lib

set l_active_library = `echo $active_library | aleph_tr -l`
if ($l_active_library == $lib) then

echo "Export library $active_library"
$aleph_proc/oracle_expdp_current_lib

else
echo "LIBRARY $lib does not exist"
endif
end