Share
 
 

Updating a Workgroup Database in Oracle

The following is checklist for the update process of a Workgroup Database in Oracle.

Note: The update scripts for an Oracle database will always update by a single major version number e.g. 2023.;0 to 2023.1, or 2023.1 to 2023.2. To update between non-consecutive major version numbers, all intermediate scripts must be run in the correct order.

From version 2023.1 you can use the software whilst using older database versions from version 2023.0 and later. Therefore you do not necessarily have to update the databases when upgrading to a new version of the software, though some functionality may be unavailable. Equally you can upgrade the software to a later database version which is not the current one. As with updating to the current format it is necessary to run the scripts in order.

  1. Download the appropriate update script(s) from the Autodesk website (or from the InfoWorks Workgroup Server installation directory for versions prior to 8.0). Make sure that you have the correct scripts for your application. Either:
    • ICM/ICMLive/InfoNet
    • WS Pro/IWLive Pro/DemandWatch Pro
  2. The script names identify the products and the from and to versions of the update process, e.g.

    Ora_update_from_ICM75IN175_to_ICM80IN180.sql

    Ora_update_roles from_ICM75IN175_to_ICM80IN180.sql

  3. In the update roles script(s):
    1. Replace the string “CHANGETHIS” with the name of the database Table Owner (as specified in the master.ini file).
    2. Replace the string “INNOVYZEUSER” with the name of the database User (as specified in the master.ini file).
  4. Using SQLPlus, logged in as the Table Owner, run the appropriate update scripts in turn to update from the current version number to the desired version number. Check that no errors are reported. Ensure that the transaction is completed.
  5. Connecting to the database using the Workgroup client should tell you that a subversion update is required. Allow the subversion update to proceed.
  6. The update is now complete.

Was this information helpful?