
Signature
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
You're right...
I went back and determined (as far as could be determined)
that the testing requirements are not high.
IOW I need a "tricycle" or "scooter"
according to your analogy.
While keeping the other options in mind,
I am now looking at the following questions:
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?
2. Can one take small databases (such as
the Oracle 9i sample db) from Oracle 9i
and loade it into DB2?
Thanks...
...
> To validate what? why? for what purpose?
>
[quoted text clipped - 5 lines]
> And my answer is roughly equivalent to "Is it a bicycle or a supersonic
> jet?"
DA Morgan - 20 Dec 2005 19:07 GMT
> You're right...
>
[quoted text clipped - 30 lines]
>>And my answer is roughly equivalent to "Is it a bicycle or a supersonic
>>jet?"
Please do not top post.
You ask about the sample database in a manner that makes me think you
are coming to Oracle from some other database product and have have no
idea what the word database means in the context of Oracle.
In Oracle the word is schema. And you should find that you have numerous
sample/demo schemas installed including SCOTT, BI, PM, HR, OE, and SH.
Try this query:
SELECT username FROM dba_users;
You will get nowhere with Oracle if you treat Oracle like a Microsoft
or IBM product. Expect massive disappointment. Alternatively: Go to
http://tahiti.oracle.com and look up "DATABASE", "INSTANCE", "SCHEMA",
"USER" and get yourself a copy of every book Tom Kyte has written.

Signature
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
Pierre Saint-Jacques - 20 Dec 2005 21:35 GMT
I gather you're looking to test on DB2.
After install, go to the first steps and you'll find you can create sample
databases for a simple db or for a datawarehouse.
It depends on what you install.
The sample db (called SAMPLE) can also get created from a command line by
opening a db2 command window and issuing: db2sampl Notice no"e" at the end.
If you want more serious testing there are tools that can be downloaded (
for a fee) to help you out.
HTH, Pierre.

Signature
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
> You're right...
>
[quoted text clipped - 29 lines]
>> And my answer is roughly equivalent to "Is it a bicycle or a supersonic
>> jet?"
Mark Townsend - 21 Dec 2005 01:14 GMT
> 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