Oracle 自己帶的Sample Sechemas 介紹

以前,很少安裝這些Sample Sechemas ,也沒研究過這些東西是幹嗎的,[@more@]

Sample Schemas

Most of the included accounts are administrative accounts, but Sample Schema accounts are also present. The Oracle Database Sample Schemas are a set of interlinked schemas that enable Oracle documentation, and Oracle by Example Series, to illustrate common database tasks:

• The human resources (hr) schema is useful for introducing basic topics. An extension to this schema supports Oracle Internet Directory demos.

• The order entry (oe) schema is useful for dealing with matters of intermediate complexity. Many datatypes are available in this schema, including nonscalar datatypes.

• The online catalog (oc) subschema is a collection of object-relational database objects built inside the oe schema.

• The product media (pm) schema is dedicated to multimedia datatypes.

• The information exchange (ix) schemas demonstrate Oracle Advanced Queuing capabilities.

• The sales history (sh) schema is designed for demos with large amounts of data. An extension to this schema provides support for advanced analytic processing.