Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Installation

Using the Database Configuration Assistant

Manually Installing the Oracle9i Sample Schemas

Prerequisites

Schema Dependencies

Installing the Human Resources (HR) Schema

Installing the Order Entry (OE) Schema and its Online Catalog (OC) Subschema

Installing The Product Media (PM) Schema

Installing the Queued Shipping (QS) Schemas

Installing the Sales History (SH) Schema

Resetting the Sample Schemas

2 Rationale

Overall Description

Human Resources (HR)

Order Entry (OE)

Product Media (PM)

Queued Shipping (QS)

Sales History (SH)

3 Diagrams

Sample Schema Diagrams

4 Oracle9i Sample Schema Scripts

About the Scripts

Master Script

mksample.sql

Human Resources (HR) Schema Scripts

hr_analz.sql

hr_code.sql

hr_comnt.sql

hr_cre.sql

hr_dn_c.sql

hr_dn_d.sql

hr_drop.sql

hr_idx.sql

hr_main.sql

Order Entry (OE) Schema Scripts

oc_comnt.sql

oc_cre.sql

oc_drop.sql

oc_main.sql

oe_analz.sql

oe_comnt.sql

oe_cre.sql

oe_drop.sql

oe_idx.sql

oe_main.sql

oe_views.sql

Product Media (PM) Schema Scripts

pm_analz.sql

pm_cre.sql

pm_drop.sql

pm_main.sql

Queued Shipping (QS) Schema Scripts

qs_adm.sql

qs_cbadm.sql

qs_cre.sql

qs_cs.sql

qs_drop.sql

qs_es.sql

qs_main.sql

qs_os.sql

qs_run.sql

qs_ws.sql

Sales History (SH) Schema Scripts

sh_analz.sql

sh_comnt.sql

sh_cons.sql

sh_cre.sql

sh_cremv.sql

sh_drop.sql

sh_hiera.sql

sh_idx.sql

sh_main.sql

sh_olp_c.sql

sh_olp_d.sql