Difference between revisions of "Oracle:Sample Database"
From mi-linux
Jump to navigationJump to search (Created page with "== 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 === <ul> <li>Go t...") |
|||
| Line 11: | Line 11: | ||
<li>Save the file to your “Documents” Personal storage folder (U:\ drive)</li> | <li>Save the file to your “Documents” Personal storage folder (U:\ drive)</li> | ||
</ul> | </ul> | ||
| + | |||
| + | === 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: | Assuming you have logged into Oracle successfully as detailed in the previous section and have saved the file to your “Documents” folder, type: | ||
Revision as of 14:14, 13 January 2016
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.
