Upgrade Guide › Upgrading Databases › Upgrading a Partitioned Oracle Database › Upgrading from 5.0

Upgrading from 5.0

These instructions upgrade your CA DLP database from 5.0 to 6.0.

To upgrade from 5.0

1. Go to the \UpgradeV5_0ToV6_0 folder:
2. Copy this subfolder to your database host server (this is not necessarily the same as the CMS host server).

   This subfolder includes Native_UpgradeToVer3_40.sql and Native_Wrapper.sql.

3. Edit Native_UpgradeToVer3_40.sql on your database host server to make the changes you require.

   In particular, you may want to specify the tablespace and storage parameters for these new objects:

   Wgn_UE_Candidates

   PK_Wgn_UE_Candidates

   Wgn_UE_Export

   PK_Wgn_UE_Export

   UK_Wgn3UserGroup

   UK_Wgn3EventAudit

4. Run the following commands as the schema owner, using the SQL*Plus utility:

   SQL> set serveroutput on size unlimited
   SQL> start Native_Wrapper.sql;
   

5. You now need to upgrade from 6.0; see the next section.