Creating an OCS Oracle Database

Create a table space and execute the $AF_HOME/db/oracle/ocs/OCS_SCEMA_DDL.sql script.

  1. Create the table space by modifying the file to assign proper table space name and location of the file including the .dbf extension in the file $AF_HOME/db/oracle/oms/CreateTableSpace.sql.
  2. Create the user and assign the table space by modifying the file $AF_HOME/db/oracle/oms/createOMSUser.sql and assign the proper username and password for every user and the table space to the user with proper quota size in the file.
  3. Connect to SQL PLUS as an OCS database user. Execute the following SQL files in order:
    1. Execute $AF_HOME/db/oracle/oms/OCS_SCHEMA_DDL.sql passing the tablespacename as an input parameter.
      For example,
      • SQL> @$AF_HOME/db/oracle/oms/OCS_SCHEMA_DDL.sql <<tablespacename>>