Difference between revisions of "Oracle:Sample Database"
| Line 28: | Line 28: | ||
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. | 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. | ||
| − | <font size="3" color="red">Note, this command only needs to be executed once | + | <font size="3" color="red">Note, this command only needs to be executed <b>once</b>. If you re-run it, the command will drop the tables you previously created, thereby losing any changes you may have made to them</font> |
Revision as of 14:25, 13 January 2016
Main Page >> Oracle and SQL >> Getting Started >> SQL*Plus
Copying the Sample Database
The sample database used in this workbook needs to be set-up first by the following steps:
1. 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)
Note, it is advisable not to save the file in any folders,or the Desktop to begin with, since that makes it hard to access via Oracle. Once the script is run, you can move the script somewhere else.
2. Run the setup script
Assuming you are logged into Oracle successfully (if not, see: using SQL*Plus) 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.
Note, this command only needs to be executed once. If you re-run it, the command will drop the tables you previously created, thereby losing any changes you may have made to them
