Wednesday, February 8, 2012

Dataset for homework 1

We have set up a small database that you can test question 1 and 2 of homework on. You can get to the tables using the names zhouhany.student, zhouhany.enroll, zhouhany.course and zhouhany.prereq. If you cannot get to these tables, please contact any TA and we will re-grant you the privilege.
Posted by at

6 comments:

  1. SuryaFebruary 9, 2012 at 1:00 AM

    Are these available in the CSE systems only?

    ReplyDelete
    Replies
    1. Jie HuFebruary 9, 2012 at 4:16 PM

      This comment has been removed by the author.

      Delete
    2. Jie HuFebruary 9, 2012 at 4:17 PM

      Yes. You should log in any CSE 64-bit Linux system first.

      Delete
  2. Saurabh KaushalFebruary 10, 2012 at 5:18 PM

    I am trying to access the data models. These are the steps which I am performing.

    1. I logged into timberlake.cse.buffalo.edu
    2. I set ORACLE_HOME by
    setenv ORACLE_HOME /util/oracle/product/current/client_1
    3. I specified the instance to connect by
    setenv TWO_TASK aos.buffalo.edu
    4. Then I typed sqlplus gave the username as my UBIT name and password specified in the class

    But I am not able to log in. Please tell me where am I going wrong.

    ReplyDelete
  3. Saurabh KaushalFebruary 12, 2012 at 9:45 PM

    I could get it...problem solved...

    ReplyDelete
  4. NareshFebruary 14, 2012 at 10:28 AM

    Any one know how to get previous command and edit it in sqlplus. I tried edit but it hangs after saving the buffer.

    ReplyDelete

Subscribe to: Post Comments (Atom)