Script to export customer libraries (Oracle Data Pump)
- 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