Installing a Fresh Copy of a Database

Run the respective script to install a fresh copy of an Oracle or PostgreSQL database if you are a new user.

  • Oracle EE users:

    Run the OMS_DDL.sql file by running the file manually on the SQL prompt. This script automatically creates a new partitioned database.

  • Postgres users:

    With a Postgres database, only a partitioned database is supported. To create a partitioned PostgreSQL database instance, run the setup.sh file under $AF_HOME/db/postgreSQL/oms.