setup

PRODUCT CENTERS

Legal | Privacy

Printer View

E-mail this page

Bookmark

Setting Up the Data Warehouse Environment

Setting Up the Data Warehousing Environment

Module Objectives

Purpose

In this module, you will modify the SH (Sales History) schema to prepare for the Data Warehousing lessons.

Prerequisites

Before starting this module, you should have:

	Completed the Preinstallation module
	Completed the Install Oracle9i Database Release 2 module
	Completed the Postinstallation module
	Completed the Review the Sample Schema module
	Downloaded the setup_dwh.zip file into your working directory and unzip

Reference Material

The following is a list of useful reference material if you want additional information about the topics in this module:

Documentation: Data Warehousing Guide

Schema changes for Sales History

Apply minor modifications to the base SALES HISTORY schema. This must be made for using the material. Some changes on existing objects are necessary, and some additional system privileges must be granted to the user SH. The SQL file for applying those changes is modifySH_92.sql. Note that this script is tested against Oracle9i Release 2 only.

1.	From a SQLPlus session connect to the ORCL* database, login as as sh/sh, and run modifySH_92.sql. @modifySH_92.sql

Module Summary

In this module, you should have:

Modified the SH (Sales History) schema to prepare for the Data Warehousing lessons.

Close Window