Contents

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience
Documentation Accessibility
Customer Benefits of Sample Schemas
About Sample Schemas
Oracle Database Sample Schemas Design Principles
Structure
Related Documents
Conventions

1 Installation

Using the Database Configuration Assistant
Manually Installing Sample Schemas
Schema Dependencies
Installing the HR Schema
Installing the OE Schema and its OC Subschema
Installing the PM Schema
Installing the IX Schema
Installing the SH Schema
Resetting Sample Schemas

2 Rationale

Overall Description
HR
OE
PM
IX
SH

3 Diagrams

Sample Schema Diagrams

4 Sample Schema Scripts and Object Descriptions

About the Scripts
Master Script
mksample.sql
HR Schema
OE Schema
PM Schema
IX Schema
SH Schema

Index