CS430/CS630 Setup for Oracle and doing SQL homework

First Steps:

1. login to dbs2.cs.umb.edu

2. edit your .cshrc as instructed in DBA email (check your cs.umb.edu email)

3. log out and in again

4. Use sqlplus to access Oracle

5. Try “create table t1(x int);” to make sure your account allows table creation

6. If time, use loadcap to load up CAP

 loadcap, Oracle script to load CAP database, is available, linked to class web page

How to use loadcap:

1. cd cs430     (or cs630)

2. cp -r /data/htdocs/cs430/loadcap .    (recursive copy to current directory, .)

3. cd loadcap               (cd to your own copy of the loadcap directory)

4. ls                        (look at files in directory, see script file loadcap)

5. loadcap user/pw    (to load CAP: need to be logged in on dbs2 for this)

How to do the homework using your own PC as much as possible:

1. On your PC, open your favorite editor to create the hw2.sql file.  This can be NotePad or WordPad or whatever you use for text files.

2. On your PC, open another window for your ssh tool (say putty.exe) and log into dbs2.cs.umb.edu and run sqlplus to get the SQL> prompt. Now sqlplus is waiting for a SQL statement to execute.

3. In the editor, type in the first SQL statement you need. Don’t forget the final ;

4. Copy and paste it into the sqlplus window and see it execute.

5. If it fails, just edit your editor buffer and repeat step 4.

6. When it finally succeeds, save your text file and go on to the next SQL statement, ...