Creating the Demo Tables

Before you start the SalesOrder example, you have to create the demo tables.

Procedure

  1. On a command line, change directory to the SalesOrder directory.
    For example, >cd TIB_ADADB_HOME\demo\bw6\SalesOrder
  2. Execute the salesorder_database_vendor.sql script in the subdirectory to create tables for your database. Use your environment-specific user ID, password, and database service.
    For example, >sqlplus userid/pswd@dbService @salesorder_ora.sql
    The script creates the items and displays the status.
  3. Execute the following script to exit the query tool:
    SQL> exit