Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Overview

• 1.1 About Sample Schemas
• 1.2 Oracle Database Sample Schemas Design Principles
• 1.3 Customer Benefits of Sample Schemas

2 Installation

• 2.1 Using the Database Configuration Assistant
• 2.2 Manually Installing Sample Schemas
  • 2.2.1 Schema Dependencies
  • 2.2.2 Guidelines for Installing Sample Schemas
  • 2.2.3 Installing the HR Schema
  • 2.2.4 Installing the OE Schema and Its OC Subschema
  • 2.2.5 Installing the PM Schema
  • 2.2.6 Installing the IX Schema
  • 2.2.7 Installing the SH Schema
• 2.3 Resetting Sample Schemas

3 Rationale

• 3.1 Overall Description
• 3.2 HR
• 3.3 OE
• 3.4 PM
• 3.5 IX
• 3.6 SH

4 Diagrams

• 4.1 Sample Schema Diagrams

5 Sample Schema Scripts and Object Descriptions

• 5.1 About the Scripts
• 5.2 Master Script
  • 5.2.1 mksample.sql
• 5.3 HR Schema
• 5.4 OE Schema
• 5.5 PM Schema
• 5.6 IX Schema
• 5.7 SH Schema

Index