Prepare database schemas in Windows

This section describes how to set up the Oracle database for use with the optional XPID component in Windows.

To set up the schemas:

1. Copy the file from <install_dir>/ohim_hrl__ installer/addons/recordlocator/xpid/oracle_db/xpid_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 xpid (&xpidpswd).
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:

   createxpidddl.sql using xpid

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