Re: Where can I find some sample data

Paul,

The scripts at asktom.oracle.com create high-volume of random data. That would be useful if I was running some performance or availability tests, which I am not. I am trying to demonstrate a web-based query/reporting tool so I need some data that looks as real as possible (but is neither proprietary, confidential nor copyrighted).

I have many Access sample databases, such as Microsoft's "Northwind Traders" sample database. Its a fairly small and simple database, but still about 500 times larger than the scott/tiger database (which also is the only samples I could find in my $ORACLE_HOME/ora91/rdbms/demo directory) . The Northwind sample looks pretty good for my demonstration so I think I'll port it to Oracle -- I just hope I don't get served a restrain order from either Larry or Bill.

Tom

"Paul Heely" <apaulh_at_computer.org> wrote in message news:blqk9ukrb1a9k3to4c8nsnubl1in8qn29a_at_4ax.com...
> On Wed, 20 Mar 2002 23:28:24 -0500, "Eric Bowman"
> <Doc435_at_mindspring.com> wrote:
>
> >Try the schemas Oracle ships to demo new features.
> >
> >%ORACLEHOME%\ora81\RDBMS\demo
> >and
> >%ORACLEHOME%\ora81\RDBMS\ADMIN
> >
> >Both of these directories create scripts that will build schema for
 sample
> >apps and demos for new features. Failing that try build one out of
 census
> >data from the university of Missouri, They have 1990 census data stored
 in a
> >way that can be extracted to a CSV file and loaded useing SQLLOADER. I
 have
> >pulled several sample datasets from there but nothing more complicated
 than
> >single table samples. However with a few different sets of parameters
 you
> >could build a pretty good schema.
> >
> >http://mcdc.missouri.edu/applications/uexplore.html
> >
> >-ERIC-
> >
> >"News" <thilbig_at_hotmail.com> wrote in message
> >news:0Jcm8.14283$XN1.1798198_at_news20.bellglobal.com...
> >> I meant to add that the scott/tiger sample just isn't enough data. I
 think
> >> the total schema is about 25 rows over 4 tables. It's impossible to
> >> demonstrate a few dozen types of reports on that amount of data. It's
 like
> >> trying to demonstrate MS Excel with a 2 columns by 2 row spreadsheet --
 just
> >> not enough for an effective demo on Oracle.
> >>
> >> I've searched Oracle's sites up and down, including OTN, and have not
 found
> >> any sample databases. Perhaps I'm just using the wrong keywords. I
 thought
> >> it would be easy to find, but I've come up totally empty. Any type of
> >> schema would be fine -- HR, Payroll, Sales -- I'll take any kind!
> >>
> >> Tom
> >>
> >>
> >
>
> This link shows a method of generating test data automatically. It
> won't create the tables for you but will fill them with data. Maybe
> It can be adapted for your needs?
>

http://asktom.oracle.com/pls/ask/f?p=4950:12:618861::NO::F4950_P12_DATE_YYYY MMDD:20020312#tag2151576678914
>
> --
> Paul
Received on Fri Mar 22 2002 - 05:25:02 CET