Follow these steps to create the OWB Workspace Owner and Users using the Repository Assistant:
Step 1: Enter the Host Name, Port Number and Oracle Service Name, which can all be found in your tnsnames.ora file.
Step 2: Select Manage Warehouse Builder Workspace
Step 3: Select Create a new Warehouse Builder workspace
Step 4: Select Create a workspace with a new user as workspace owner
Step 5: Enter the SYS user name and password
Step 6: Enter the Workspace Owner's User Name, e.g. ORCL, and Password. Also enter the Workspace Name, e.g. CURAMBI
Step 7: Enter the OWBSYS user name and password
Step 8: Accept the defaults or else change the Tablespaces
Step 9: Accept the default or else change the Language
Step 10: Create 5 new schemas - CuramST, CuramDW, CuramDM, CuramDMO and CuramBIROLE. These will be created as Schemas on your database so please name them as Project Standards require.
Review the Summary and click finish to build the Repository and create the Target Schemas on the Database.