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

Native Script Upgrades from 14.0

These instructions upgrade your CA DataMinder database from 14.0 to 14.1.

To upgrade from 14.0 using the native upgrade scripts

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

   This subfolder includes Native_UpgradeToVer3_80.sql and Native_Wrapper.sql.

3. Edit Native_UpgradeToVer3_80.sql on your database host server to make the changes you require.
4. 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.

5. Upgrade the data warehouse. Do one of the following:
   • Run the CA DataMinder server installation wizard. For instructions, see the 'Data Warehouse' chapter in the Platform Deployment Guide.
   • Run the data warehouse native DDL scripts if you want to customize storage for the data warehouse. For instructions, see the 'Database Storage and Partitioning' chapter in the Database Guide.
6. 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.

7. (Optional) Follow this step only if you have a pre-existing 14.0 data warehouse that is not currently partitioned.

   The following command partitions your data warehouse with partition dates that match the CMS. Run this command as the schema owner, using the SQL*Plus utility:

   SQL> EXEC Wgn_Partition_Util.wgn_partition_tables( 
     partition_dates => Wgn_Partition_Util.get_partition_dates(Wgn_Partition_Util.wgn_db_type_cms) 
     , db_type => Wgn_Partition_Util.wgn_db_type_DW 
     , Partition_Options => Wgn_Partition_Util.wgn_opt_Convert_to_Partitioned 
     , new_tablespace => 'WGNDATADW' 
     , new_indextablespace => 'WGNDATADWIDX' 
     , pdebug => True );
   

8. You now need to upgrade from 14.1. See the next section.