Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: validation testing -- use TPC-C? (or what?)
z wrote:
>
> 1. Presume Oracle 9i installation has succeeded.
> Oracle 9i reputedly has a "sample" database.
> Where is it, how can I load it and play with it?
> Are there sample queries?
There are a number of sample schemas provided in the default install. Look for users HR (for a Human Resources related schema), OE (for an order entry related schema), SH (for a sales history related schema), PM (for a product management related schema) and IX (for an information exchange related schema).
Each schema builds on the previous, and introduces new concepts.
For example OE adds object types
SH is a large data warehousing schema
PM has media types
IX adds queues and replicants
They are widely used in the examples in all Oracle documentation,
cirriculum and collateral - see
http://www.oracle.com/pls/db102/to_toc?pathname=server.102%2Fb14198%2Ftoc.htm
for a description
>
> 2. Can one take small databases (such as
> the Oracle 9i sample db) from Oracle 9i
> and loade it into DB2?
Some of the basic schemas, such as HR, should unload and load easily into DB2. Others, as indicated, use specific Oracle features that may be more difficult to translate into DB2 Received on Tue Dec 20 2005 - 19:14:22 CST