||Human Resources. The HR schema is the schema that provides support for most examples that had been using the scott emp and dept tables.
HR is simple, uses only scalar data types, and has small tables.
||Order Entry. OE schema has two parts: the OE schema proper and an object-relational part called the OC (Online Catalog) subschema.
The OE structure provides the basis of a simplistic order-entry scenario and includes a wide range of data types, including those that are new in Oracle9i Database.
The OE schema also contains synonyms to HR tables.
||Product Media. PM schema is dedicated to content management. Within PM, the online_media table makes use of Oracle interMedia, and the print_media table uses large-object (LOB) data types.
Within the print_media table, the ad_textdocs_ntab column contains a nested table. The PM tables contain videos, audio tracks, images, documents, and text files for a few selected products from the OE schema.
||Sales History. SH schema is by far the biggest of all sample schemas. It is the schema you want to consider for tests that involve large volumes of data.
A few of the features the sh schema uses are partitioning, bitmap join indexes, an external table, and online analytical processing (OLAP).
||Queued Shipping. QS logical schema consists of a group of schemas. The schema names all start with "qs."
They host message queues and let you experiment with Oracle's Advanced Queuing features.