DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Sample database?

  1. #1
    Join Date
    Aug 2001
    Posts
    42
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    There is a demo schema that comes with oracle. Check out your $ORACLE_HOME/sqlplus/demo/demobld.sql script...
    Jeff Hunter

  3. #3
    Join Date
    Aug 2001
    Posts
    42
    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

  4. #4
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    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.

  5. #5
    Join Date
    Apr 2002
    Posts
    29
    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

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    hi

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

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width