Update the Oracle Database Schema - Brainware Intelligent Capture - Foundation 23.1 - Foundation 23.1 - Brainware - external

Brainware Intelligent Capture Update
Platform
Brainware
Product
Brainware Intelligent Capture
Release
Foundation 23.1
License
Note: After the update, you cannot revert the database schema to an older version.

To update the Oracle database schema, complete the following steps.

  1. Ensure that the BIC user has the appropriate permissions. For more information, see "Create the database user" in the Brainware Intelligent Capture Installation Guide.
  2. To execute the update script using SQL Developer, complete the following substeps.
    1. Configure a connection for the BIC user.
    2. From the [drive:]\[setup directory]\FirstPart\Database\UpdateScripts\Oracle directory, open the BRW_Upgrade_Database.sql script.
    3. Ensure that the connection is set to the BIC user and then execute the script.
  3. To execute the update script using SQL Plus, complete the following substeps.
    1. Start SQL Plus and connect to the database as the BIC user.
    2. From the [drive:]\[setup directory]\FirstPart\Database\UpdateScripts\Oracle directory, execute the BRW_Upgrade_Database.sql script.
  4. Review the Messages pane for errors.
    Note: If there are errors, you can run the script as often as required.
  5. In addition, when upgrading from version EP2 or earlier, complete the following steps.
    1. Clear the plan cache.
    2. Rebuild all indexes.