Re: validation testing -- use TPC-C? (or what?)

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 20 Dec 2005 11:07:32 -0800
Message-ID: <1135105638.323249@jetspin.drizzle.com>

z wrote:
> 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...
>
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1134499485.846757_at_jetspin.drizzle.com...
>

>>z wrote:

>
>
> ...
>
>

>>To validate what? why? for what purpose?
>>
>>There is a huge difference between validation for security and
>>validation for transaction for a banking system.
>>
>>You inquiry is roughly equivalent to "How an I test a vehicle with

>
> wheels?"
>

>>And my answer is roughly equivalent to "Is it a bicycle or a supersonic
>>jet?"
>>-- 
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)

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.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Dec 20 2005 - 13:07:32 CST