Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Overview

• About Sample Schemas
• Oracle Database Sample Schemas Design Principles
• Customer Benefits of Sample Schemas

2 Installation

• Using the Database Configuration Assistant
• Manually Installing Sample Schemas
  • Schema Dependencies
  • Guidelines for Installing Sample Schemas
  • 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
• Uninstalling Sample Schemas

3 Rationale

• Overall Description
• HR
• OE
• PM
• IX
• SH

4 Schema Diagrams

• Sample Schema Diagrams

5 Sample Schema Scripts and Object Descriptions

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

Index