Upgrade Guide › Upgrading Databases › Database Upgrade Procedure › Oracle: Post-upgrade Table Change

Oracle: Post-upgrade Table Change

Only required if upgrading from version 6.0 or earlier.

After upgrading your CMS, you need to modify the Wgn3EventParticipant table, redefining the AddressUID columns as NOT NULL.

To redefine the AddressUID columns

1. Run the pre‑flight check script, wgn_post_upgrade_pfc.sql. This script estimates how long the table update will take.

   Find this script in the\Support\Upgrade12\Oracle folder on your CA DLP distribution media.

   Using SQL Plus, connect to the CA DLP database and run this command as the CA DLP schema owner (typically APMOWNER on version 6.0 CMSs):

   @wgn_post_upgrade_pfc
   

2. Run the wgn_common_upgrade_22b.sql to modify the Wgn3EventParticipant table..

   Find this script on your CMS in the \System\Scripts\Oracle subfolder of CA DLP installation folder:

   Using SQL Plus, run this script as the CA DLP schema owner (typically APMOWNER on version 6.0 CMSs):

   @wgn_common_upgrade_22b
   

3. Back up your database again to create a new restore point.