We recommend creating the BIC database in a separate schema which is not shared with any other programs. To execute the creation scripts, use the owner of the schema created for BIC. Complete the following steps.
-
To execute the installation scripts using
SQL Developer, complete the following substeps.
- Configure a connection for the BIC user.
- From the [drive:]\[setup directory]\FirstPart\Database\CreationScripts\Oracle directory, open the BrwCreateDatabase.sql script.
- Ensure that the connection is set to the BIC user and then execute the script.
- From the [drive:]\[setup directory]\FirstPart\Database\UpdateScripts\Oracle directory, open the BRW_Upgrade_Database.sql script.
- Ensure that the connection is set to the BIC user and then execute the script.
-
To execute the installation scripts using
SQL Plus, complete the following substeps.
- Start SQL Plus and connect to the database as the BIC user.
- From the [drive:]\[setup directory]\FirstPart\Database\CreationScripts\Oracle directory, execute the BrwCreateDatabase.sql script.
- From the [drive:]\[setup directory]\FirstPart\Database\UpdateScripts\Oracle directory, execute the BRW_Upgrade_Database.sql script.