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