Upgrade Guide › Upgrading Databases › Upgrading a Partitioned Oracle Database › Native Script Upgrades from 14.5

Native Script Upgrades from 14.5

These instructions upgrade your CA DataMinder database from 14.5 to 14.6.

To upgrade from 14.5 using the native upgrade scripts

1. Go to the \UpgradeV14_5ToV14_6 subfolder in your CA DataMinder distribution image.
2. Copy this subfolder to your database host server.

   This subfolder includes Native_UpgradeToVer3_100.sql and Native_Wrapper.sql.

3. Run the following command as the schema owner, using the SQL*Plus utility:

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

   Important! Always use a version of SQL*Plus that matches your version of Oracle. Errors can occur if you use an older version of SQL*Plus to run scripts against a newer version of Oracle.

4. Upgrade the data warehouse.

   Run the CA DataMinder server installation wizard. For instructions, see the 'Data Warehouse' chapter in the Platform Deployment Guide.

5. Upgrade the CMS by running setup.exe.

   Find setup.exe in the root of your CA DataMinder distribution image. For details about installing a CMS, see the Platform Deployment Guide.

   Run this command as the schema owner, using the SQL*Plus utility:

   SQL> EXEC Wgn_Partition_Util.wgn_partition_new_table(
          new_table_name  => 'WGN3RELATEDEVENT',
          template_name   => 'WGN3EVENT',
          pdebug          => True,
          db_type         => Wgn_Partition_Util.wgn_db_type_CMS,
          Tablespace_Name => Wgn_Partition_Util.wgn_get_tablespace_name('WGN3RELATEDEVENT')
   );
   

   This command partitions the new WGN3RELATEDEVENT table with partition dates that match the Wgn3Event.