Dream Home database
Return to CS G102 home page
Instructions to set the database and to load the data
First create a new directory, change the permissions of the directory so you will be able to read,write and execute but noone else and download all the files following the
link below to the directory you have just created.
Get in the directory you have just created.
At the Unix prompt type
> sqlplus
After you give your username and password the SQL prompt will appear.
To create the database tables type:
SQL> start create.sql
SQL> exit
To load the data type:
> sqlldr {username} control= {ctl file}
for each one of the tables in the database.
e.g.
> sqlldr ekanou control=Branch.ctl
Repeat the same command for all the .ctl files (Staff.ctl, PropertyForRent.ctl, Client.ctl, PrivateOwner.ctl, Viewing.ctl, Registration.ctl)
The files necessary to create the database and load the data.
Download the files