Oracle:Sample Database

Copying the Sample Database

The sample database used in this workbook needs to be set-up first by the following steps:

Download the setup script

• Go to the Oracle web server: http://oradb-srv.wlv.ac.uk
• Look for the link called sqlload.sql setup script
• Right click on this and depending on your browser, select “Save Link As….” or “Save Target As….”
• Save the file to your “Documents” Personal storage folder (U:\ drive)

Run the setup script

Assuming you have logged into Oracle successfully as detailed in the previous section and have saved the file to your “Documents” folder, type:

 @  u:\sqlload

and press RETURN.

If you have saved your file somewhere else, for example, a memory stick, then replace the u:\ with the location of your file, including any subfolders, e.g., e:\oracle\sqlload

This sets up your database on the central server and this same database can be accessed from the MI labs, other University labs and from home.