Oracle star and snowflake schema

Hi, Oracle has the scott/tiger schema with HR employee tables and salaries etc.

What I want are scripts to create a schema that contains an example of a data warehouse, both snowflake and star schema.

I am not wanting anyone to help me write them, I just want to know whether sample scripts exist and if so, where, and which one is the best implementation of the two examples.

I am running Oracle 9.02 on Windows XP.

Thank you

John
John BolterAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
I always start in the docs.

For a Star, check out the Sales History sample schema:


http://docs.oracle.com/cd/B10501_01/server.920/a96520/schemas.htm

The Sales History sample schema (the basis for most of the examples in this book) uses a star schema.

http://docs.oracle.com/cd/B10501_01/server.920/a96539/installa.htm#5595
Installing the Sales History (SH) Schema


Still looking to see if they added snowflake samples anywhere.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John BolterAuthor Commented:
Ah, the "sh" schema. I didn't even know it existed.
Thank you
0
slightwv (䄆 Netminder) Commented:
Not finding any Snowflake sample schemas.

Hopefully another Expert will be able to post something later.
0
John BolterAuthor Commented:
It is fine, I am sure I can work it out.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.