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.
Additional Information
{As described in Article 000040442 (Upgrade Express: exported z00p takes 11 hours -- and 50 times the space), the export/import of the z00p can actually take longer than rebuilding the z00p via the publish-04 Service on the target server.}
It would *seem* that something like exclude=TABLE:"= 'Z00P'" :
expdp $ALEPH_ADMIN SCHEMAS=$lib exclude=TABLE:"= 'Z00P'" DIRECTORY=${lib}_DIR_UE DUMPFILE=${lib}%U.dmp FILESIZE=2g
PARALLEL=2 LOGFILE=exp${lib}.log compression=METADATA_ONLY JOB_NAME=${lib}_JOB
should work, but I could *not* get it to work. The PARFILE method described in the above Procedure *did* work.
- Article last edited: 28-Nov-2016