Sample database?

[L-Carvone]

I have begun training for 8i OCP certification but I lack any real world professional experience. To attempt to partially counteract this I want to play around with some test databases to apply my new learnings. Anyone have any links for downloading/purchasing simple databases? Or would it be better to create my own?

Thanks in advance

L-Carvone

[marist89]

There is a demo schema that comes with oracle. Check out your $ORACLE_HOME/sqlplus/demo/demobld.sql script...

[L-Carvone]

Thanks Jeff...I have identified that schema as a start but am curious if multiple schema of different types (i.e financial, HR, manufacturing) would give me a more rounded understanding of the capabilities as well as make me more rounded as far as job possibilities down the road??.....

All thoughts appreciated

L-Carvone

[dragon99]

Try to get oracle 9i. With 9i, there are a couple of sample schemas. One example from HR schema:

SQL> select table_name from user_tables;

TABLE_NAME
------------------------------
COUNTRIES
DEPARTMENTS
EMPLOYEES
JOBS
JOB_HISTORY
LOCATIONS
REGIONS

7 rows selected.

Each table has more than 100 rows. It is good for studying database desgine too.

[kyleknicks]

I have found the demobld.sql and the demodrop.sql scripts for my 9i for win98... how do i run these? thanks for any help, kyle

[hrishy]

hi

You can run it easily from sql plus.with @demo.sql

regards
Hrishy