Oracle

To run the scripts for Oracle:

  1. Start SQL Developer or SQL*Plus Worksheet. Your Oracle user must have the DBA role granted.
  2. Open a query window and paste in the contents of the database name_ CreateEmptyNavigationDatabase_Oracle.sql script. For example:
    CPMNavigation_CreateEmptyNavigationDatabase_Oracle.sql
  3. Execute the script.
  4. Connect as the navigation user created in the first script.
  5. Open a query window and paste in the contents of the database name_ CreateNavigationSchema_Oracle.sql script. For example:
    CPMNavigation_CreateNavigationSchema_Oracle.sql
    If you are creating the database for the first time, you will see a message when running this script. The script drops the tables and a message will display if the tables do not exist. The database is setup properly and the message can be ignored.
  6. Execute the script.

If you are overwriting an existing database, you can skip steps 2 and 3.