How to exclude z00p (publishing set) from the upgrade process to Aleph 22

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

Desired Outcome Goal:
Exclude z00p (publishing set table) from the extract when using the Oracle Data Pump

Procedure:
When you are using the automatic Oracle Data Pump extract (included into the Upgrade Express kit 21 - 22) you could change the extract script in the source environment as follows

A. Exclude Z00P (publishing set):
./exlibris/aleph/upgrade_express_2101_2201
./upgrade_express_2101_2201/util/oracle_expdp_current_lib_ue.backup util/oracle_expdp_current_lib_ue

change from
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

to
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 EXCLUDE=TABLE:"IN('Z00P')"

This will extract all data from the previous Aleph version except z00p table.  

Note:  we have found that this doesn't always work and have had to use the "Alternate solution" described in Additional Information below.

B. You will have to rerun the Initial Publishing Process (publish-04) in Aleph 22.  Note that Upgrade Express will *not* create the z00p on the target instance, and before running publish-04, you will need to recreate the z00p in the $usr_library, as described in the article "publish-04: z00p does not exist".