Creating PostgreSQL Tables

A script has been added for creating Postgres tables.

Procedure

  1. Create a table space for the OCS database by running the following script: $AF_HOME/db/postgreSQL/oms/dbscripts/create_tablespace.sql.
  2. Create the database user for OCS by running the following script: $AF_HOME/db/postgreSQL/oms/dbscripts/create_user.sql.
  3. Run the following script: $AF_HOME/db/PostgreSQL/ocs/ocs_schema_ddl.sql
    Or you can copy ocs_schema_ddl.sql to $AF_HOME/db/postgreSQL/oms/dbscripts and run setup.sh or setup.cmd from $AF_HOME/db/postgreSQL/oms/.