Oracle Database at Temple

The Oracle database system is set up in the following way:

• In Oracle, a database is a logical structure that can be subdivided into accounts, where each account can define its own schema.  A schema is a set of objects that include tables, column (field) definitions and table relations.

• The lab that you can use is 200 in Wachman Hall.

• The entire class is assigned into a single database, named cisora.   Each student is assigned a user account within the cisora database.   The Oracle account names are of the form C331001nn where nn is a serial number 00, 01, 02, 03, ... assigned to you.  You should change the default password the first time you access your Oracle account.  The first character of the password must be a letter.  To change your password in the database, log onto the database under the old password using SQL*Plus or SQLPlus Worksheet.  Then enter the SQL command:
  
  Alter User <User Name> Identified By <New Password>
  
  Remember to start your new password with a letter.
  
  Every Oracle client application (tool) must connect to a database; therefore, you will be asked to login every time you run a client (or when the client needs to connect to the database).  The login requires three items: Your account name, password and a connect string, which is the database name, cisora.