[ORACLE][Sample Schemas].pdf

Oracle9i

Sample Schemas

Release 2 (9.2)

March 2002

Part No. A96539-01

Oracle9 i Sample Schemas, Release 2 (9.2)

Part No. A96539-01

Contributors: Alexander Hunold, Diana Lorentz, Neena Kochhar, Lex de Haan, Nancy Greenberg,

Nagavalli Pataballa, Den Raphaely, David Austin, Bill Gietz, Hermann Baer, Shelley Higgins, Brajesh Goyal,

Shailendra Mishra, Geoff Lee, and Susan Mavris

The Programs (which include both the software and documentation) contain proprietary information of

Oracle Corporation; they are provided under a license agreement containing restrictions on use and

disclosure and are also protected by copyright, patent and other intellectual and industrial property

laws. Reverse engineering, disassembly or decompilation of the Programs, except to the extent required

to obtain interoperability with other independently created software or as speciﬁed by law, is prohibited.

The information contained in this document is subject to change without notice. If you ﬁnd any problems

in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this

document is error-free. Except as may be expressly permitted in your license agreement for these

Programs, no part of these Programs may be reproduced or transmitted in any form or by any means,

electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.

If the Programs are delivered to the U.S. Government or anyone licensing or using the programs on

behalf of the U.S. Government, the following notice is applicable:

Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial

computer software" and use, duplication, and disclosure of the Programs, including documentation,

shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.

Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer

software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR

52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500

Oracle Parkway, Redwood City, CA 94065.

The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently

dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,

redundancy, and other measures to ensure the safe use of such applications if the Programs are used for

such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the

Programs.

Oracle is a registered trademark, and Oracle9 i and SQL*Plus are trademarks or registered trademarks of

Oracle Corporation. Other names may be trademarks of their respective owners.

Contents

Send Us Your Comments .................................................................................................................. vii

Preface ............................................................................................................................................................ ix

1 Installation

Using the Database Conﬁguration Assistant ................................................................................ 1-2

Manually Installing the Oracle9 i Sample Schemas ..................................................................... 1-3

Prerequisites .................................................................................................................................. 1-3

Schema Dependencies.................................................................................................................. 1-4

Installing the Human Resources (HR) Schema ........................................................................ 1-5

Installing the Order Entry (OE) Schema and its Online Catalog (OC) Subschema ............ 1-5

Installing The Product Media (PM) Schema............................................................................. 1-8

Installing the Queued Shipping (QS) Schemas ........................................................................ 1-8

Installing the Sales History (SH) Schema.................................................................................. 1-9

Resetting the Sample Schemas ...................................................................................................... 1-10

2 Rationale

Overall Description ............................................................................................................................ 2-2

Human Resources (HR) ..................................................................................................................... 2-2

Order Entry (OE) ................................................................................................................................. 2-3

Product Media (PM) ........................................................................................................................... 2-4

Queued Shipping (QS) ...................................................................................................................... 2-4

Sales History (SH) ............................................................................................................................... 2-5

iii

3 Diagrams

Sample Schema Diagrams ................................................................................................................. 3-2

4 Oracle9i Sample Schema Scripts

About the Scripts ................................................................................................................................. 4-2

Master Script ........................................................................................................................................ 4-2

mksample.sql................................................................................................................................. 4-2

Human Resources (HR) Schema Scripts ......................................................................................... 4-5

hr_analz.sql.................................................................................................................................... 4-5

hr_code.sql ..................................................................................................................................... 4-6

hr_comnt.sql .................................................................................................................................. 4-8

hr_cre.sql ...................................................................................................................................... 4-13

hr_dn_c.sql................................................................................................................................... 4-21

hr_dn_d.sql .................................................................................................................................. 4-35

hr_drop.sql................................................................................................................................... 4-36

hr_idx.sql...................................................................................................................................... 4-37

hr_main.sql .................................................................................................................................. 4-39

Order Entry (OE) Schema Scripts .................................................................................................. 4-41

oc_comnt.sql ................................................................................................................................ 4-42

oc_cre.sql ...................................................................................................................................... 4-42

oc_drop.sql................................................................................................................................... 4-50

oc_main.sql .................................................................................................................................. 4-51

oe_analz.sql.................................................................................................................................. 4-52

oe_comnt.sql ................................................................................................................................ 4-53

oe_cre.sql...................................................................................................................................... 4-57

oe_drop.sql .................................................................................................................................. 4-64

oe_idx.sql ..................................................................................................................................... 4-65

oe_main.sql .................................................................................................................................. 4-67

oe_views.sql................................................................................................................................. 4-70

Product Media (PM) Schema Scripts ............................................................................................. 4-72

pm_analz.sql................................................................................................................................ 4-72

pm_cre.sql .................................................................................................................................... 4-73

pm_drop.sql................................................................................................................................. 4-76

pm_main.sql ................................................................................................................................ 4-76

Queued Shipping (QS) Schema Scripts ....................................................................................... 4-80

qs_adm.sql ................................................................................................................................... 4-80

qs_cbadm.sql ............................................................................................................................... 4-82

qs_cre.sql...................................................................................................................................... 4-84

qs_cs.sql........................................................................................................................................ 4-86

qs_drop.sql .................................................................................................................................. 4-87

qs_es.sql ....................................................................................................................................... 4-94

qs_main.sql .................................................................................................................................. 4-95

qs_os.sql ..................................................................................................................................... 4-101

qs_run.sql................................................................................................................................... 4-103

qs_ws.sql .................................................................................................................................... 4-113

Sales History (SH) Schema Scripts .............................................................................................. 4-116

sh_analz.sql ............................................................................................................................... 4-116

sh_comnt.sql .............................................................................................................................. 4-117

sh_cons.sql ................................................................................................................................. 4-124

sh_cre.sql.................................................................................................................................... 4-125

sh_cremv.sql .............................................................................................................................. 4-134

sh_drop.sql ................................................................................................................................ 4-135

sh_hiera.sql ................................................................................................................................ 4-137

sh_idx.sql ................................................................................................................................... 4-140

sh_main.sql ................................................................................................................................ 4-142

sh_olp_c.sql ............................................................................................................................... 4-146

sh_olp_d.sql............................................................................................................................... 4-197

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: