Re: Where can I find some sample data

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_YYYYMMDD:20020312#tag2151576678914

--
Paul