The sample schemas contain scripts for the following types of tables:
Human Resources: The Human Resources (HR) schema is a basic relational database schema. There are six tables in the HR schema: Employees, Departments, Locations, Countries, Jobs, and Job_History. The Order Entry (OE) schema has links into HR schema.
Order Entry: The Order Entry (OE) schema builds on the purely relational Human Relations (HR) schema with some object-relational and object-oriented features. The OE schema contains seven tables: Customers, Product_Descriptions, Product_Information, Order_Items, Orders, Inventories, and Warehouses. The OE schema has links into the HR schema and PM schema. This schema also has synonyms defined on HR objects to make access transparent to users.
Product Media: Product Media (PM) schema includes two tables, online_media and print_media, one object type, adheader_typ, and one nested table, textdoc_typ. The PM schema includes interMedia and LOB column types. Note: To use interMedia Text you must create an interMedia Text index.
Sales History: The Sales History (SH) schema is an example of a relational star schema. It consists of one big range partitioned fact table SALES and five dimension tables: TIMES, PROMOTIONS, CHANNELS, PRODUCTS and CUSTOMERS. The additional COUNTRIES table linked to CUSTOMERS shows a simple snowflake.
Queued Shipping: The Queued Shipping (QS) schema is actually multiple schemas that contain message queues.
Sample Schemas can be installed automatically for you by the Database Configuration Assistant or you can install it manually at a later time. The schemas and installation instructions are described in detail in Oracle Sample Schemas.
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.