How to exclude Z00P_SEGNAME LOBSEGMENT from export

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

Desired Outcome Goal:
Exclude the huge Z00P_SEGNAME LOBSEGMENT from:
* the Upgrade Express "Create Customer Data",
* the oracle_expdp_aleph_libs proc, or
* some other export script which executes the Oracle "expdp" command.

Procedure:
In Upgrade Express, the expdp command which needs to be changed is in
* for the regular case, ,/upgrade_express_2101_2201/util/oracle_expdp_current_lib_ue .
* for the case of TWO_TASK, ,/upgrade_express_2101_2201/util/expdp_on_two_task.csh .
In other (non-Upgrade Express) cases, the $aleph_proc/oracle_expdp_current_lib will need to be changed.  (See below.)

1. Add a PARFILE parameter to the expdp command in the proc:

expdp $ALEPH_ADMIN SCHEMAS=$lib DIRECTORY=${lib}_DIR_UE DUMPFILE=${lib}%U.dmp FILESIZE=2g PARALLEL=2 LOGFILE=exp${lib}.log compression=METADATA_ONLY JOB_NAME=${lib}_JOB PARFILE=mypar.par

Note: in the case of the regular Upgrade Express the *full path* ( PARFILE=/exlibris/aleph/upgrade_express_2101_2201/util/mypar.par ) needs to be specified in ./util/oracle_expdp_current_lib_ue, that is:

expdp $ALEPH_ADMIN SCHEMAS=$lib DIRECTORY=${lib}_DIR_UE DUMPFILE=${lib}%U.dmp FILESIZE=2g PARALLEL=2 LOGFILE=exp${lib}.log compression=METADATA_ONLY JOB_NAME=${lib}_JOB PARFILE=/exlibris/aleph/upgrade_express_2101_2201/util/mypar.par

2. Create a file "mypar.par" in the same directory as the proc, containing the following, single line:

exclude=table:"IN('Z00P')"

Note:  When running the $aleph_proc/oracle_expdp_aleph_libs  procedure (separate from Upgrade Express), the above change would be made to the expdp line in the $aleph_proc/oracle_expdp_current_lib file.