Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Where can I find some sample data
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
>
>
Received on Wed Mar 20 2002 - 22:28:24 CST