Difference between revisions of "Oracle:Sample Database"
From mi-linux
Jump to navigationJump to search| Line 8: | Line 8: | ||
<li>Go to the Oracle web server: http://oradb-srv.wlv.ac.uk</li> | <li>Go to the Oracle web server: http://oradb-srv.wlv.ac.uk</li> | ||
<li>Look for the link called <i>sqlload.sql setup script</i></li> | <li>Look for the link called <i>sqlload.sql setup script</i></li> | ||
| − | <li>Right click on this and depending on your browser, select <i>Save Link As....</i> or <i>Save Target As….</i></li> | + | <li>Right click on this and depending on your browser, select <i>Save Link As....</i>, <i>Save Page As....</i> or <i>Save Target As….</i></li> |
<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> | ||
Revision as of 14:16, 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...., Save Page 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.
