Sun B2B Suite eXchange Integrator User's Guide

ProcedureTo run the command scripts that call SQL scripts to install the schema

  1. Open a command prompt and change directories to the local directory where you saved the .cmd scripts in the previous procedure.

    It is assumed you have already edited setenv.cmd appropriately, and createtablespaces.sql if necessary.

  2. Enter the following command:


    createtablespaces

    The script starts SQL*Plus, invokes an SQL script to create table spaces, and ends.

  3. Enter the following command:


    createdb

    The script starts SQL*Plus and invokes an SQL script to create a new user entry:

    • In response to the first prompt, supply an end username, such as: ex510A

    • In response to the prompt, supply a password for this end user, such as: ex510A

      The script creates a new user/password combination, invokes other SQL scripts to update the database instance, and then ends.

  4. Repeat step Running Database Scripts to Set Up the eXchange IntegratorDatabase as needed to create other user/password entries for eXchange Integrator users.

    You have installed the eXchange schema onto the eXchange database instance and created user/password combinations. End users can create Oracle OTDs based on this database, and can use it for message tracking and other eXchange Integrator functions.