Prepare database schemas in Windows

This section describes how to configure the Oracle database for use with the optional DSUB.

To configure Oracle database for use with DSUB:

1. Copy the file from <install_dir>/ohim_hrl__ installer/addons/recordlocator/dsub/oracle_db/dsub_oracle_db_scripts.zip to the host where the SQL Plus client is present in the path.
2. Log in to the host where you copied dsub_oracle_db_scripts.zip and extract its contents.
3. Change the directory to the path where you extracted the files.
4. Update create_tblspc_users.sql with the Oracle database-specific Tablespace information and new passwords for the user dsub (&dsubpswd).
5. Through SQL Plus, use admin or an ID in the Oracle database with access to create table spaces and users to execute create_tblspc_users.sql.
6. Execute the following script through SQL Plus using the IDs you created:

   createdsubddl.sql using dsub

7. After successfully creating schemas, remove create_tblspc_users.sql.