|Oracle9i Sample Schemas
Release 1 (9.0.1)
Part Number A90129-01
Oracle has been using the schema
SCOTT with its two prominent tables
DEPT tables for a long time. With advances in Oracle's technology, these tables have become inadequate to show even the most basic features of the Oracle database and other Oracle products. As a result, many other schemas have been created over the years to suit the needs of product documentation, courseware, and software development and application demos.
The new Oracle9i Sample Schemas serve the purpose of providing a common platform for examples in Oracle9i and future releases. It is not possible to convert all examples throughout our documentation to this new environment at one time, but all examples will be converted as material is updated.
The new Oracle9i Sample Schemas are a set of interlinked schemas. This set of schemas is aimed at providing a layered approach to complexity:
HR) for introducing basic topics. An extension to this schema supports Oracle Internet Directory demos.
OE) for dealing with matters of intermediate complexity. A multitude of datatypes is available in this schema.
The Online Catalog (
OC) subschema is a collection of object-relational database objects built inside the
QS(Queued Shipping) to demonstrate Oracle Advanced Queuing capabilities.
SH). An extension to this schema provides support for advanced analytic processing.
OEschemas should not become overly complex by the addition of features, but rather should provide a graduated path from the simple to intermediate levels of database use.