Oracle8i Application Developer's Guide - XML Release 3 (8.1.7) Part Number A86030-01 |
Library | Service | Contents | Index

B2B XML Application: Step by Step , 9 of 32

## XML B2B Application: Setting Up the Database Schema

The following schema scripts are provided here in the order in which they should be executed:

- Create and Build the Retailer and Supplier Schemas

  - SQL Example 1: Set up the Retailer and Supplier Environment -- BuildAll.sql

  - This calls, SQL Example 2: Create and Populate the Retailer-Supplier Schema -- BuildSchema.sql

- Create the AQ Environment and Queue Tables

  - SQL Example 3: Set Up the Environment for AQ -- mkAQUser.sql

  - SQL Example 4: Call the AQ Queue Creation Scripts -- mkQ.sql. This calls:

    - SQL (PL/SQL) Example 5: Create Table, AppOne_QTab -- mkQueueTableApp1.sql

    - SQL (PL/SQL) Example 6: Create Table, AppTwo_QTab -- mkQueueTableApp2.sql

    - SQL (PL/SQL) Example 7: Create Table, AppThree_QTab -- mkQueueTableApp3.sql

    - SQL (PL/SQL) Example 8: Create Table, AppFour_QTab -- mkQueueTableApp4.sql

- Create the Broker Schema Including XSL Stylesheet Table

  - SQL Example 9: Create Broker Schema -- mkSSTables.sql.

    This calls:

  - SQL (PL/SQL) Example 10: Input XSL data into CLOB. Populate the Broker Schema -- setup.sql

- Cleaning Up Your Environment and Preparing to Rerun Application

  - SQL Example 11: Stops and Drops Queue Applications. Starts Queue Applications -- reset.sql

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index