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

Native Script Upgrades from 6.0

These instructions upgrade your CA DataMinder database from 6.0 to r12.0.

To upgrade from 6.0

1. Go to the \UpgradeV6_0ToV12_0 subfolder:
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_50.sql and Native_Wrapper.sql.

3. Edit Native_UpgradeToVer3_50.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:

   Captured Data Table

   Wgn3ReviewQueue

   Note: By default for new CA DataMinder installations, this table is assigned to the WGNDATA tablespace.

   Capture Data Indexes

   IX_Wgn3ReviewQueue_Group

   IX_Wgn3ReviewQueue_User

   Note: By default for new CA DataMinder installations, these indexes are assigned to the WGNDATAIDX tablespace.

   Other Data Tables

   Wgn3JobHistory

   Wgn3JobState

   Wgn3UserAddressEx

   Wgn3ReviewMetrics

   Wgn3RTReviewMetrics

   Wgn3RTReviewTotals

   Wgn3RTReviewQueue

   Wgn3RTEventSlice

   Note: By default for new CA DataMinder installations, these tables are assigned to the WGN tablespace.

   Other Data Indexes (WGNIDX)

   PK_Wgn3JobHistory

   PK_Wgn3UserAddressEx

   IX_Wgn3UserAddrEx_UserID

   PK_Wgn3ReviewMetrics

   IX_Wgn3RTReviewTotals_Group

   IX_Wgn3RTReviewQueue_Group

   IX_WGN3RTEventSlice_Group

   Note: By default for new CA DataMinder installations, these indexes are assigned to the WGNIDX tablespace.

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. You now need to upgrade from r12.0; see the next section.