Byrons Instruction

Hi Mark,
I’m sending you the portion of the setup instructions for your SQL class for the 2nd part. You need to run the reset script. The database name is T5 and there are 15 student accounts.
This course is comprised of two modules. The first module is Oracle Database 10g: SQL Fundamentals I. The second module is Oracle Database 10g: SQL Fundamentals II. When the first module ends (at the end of the third day), the accounts need to be reset to match the course material for the second module. These are the directions to reset the course accounts for the second module.
1. On the Instructor machine only: In the labs\instr\reset folder resides the reset.sql file.
2. Drag the reset.sql file to the desktop.
3. The instructor is responsible for running the contents of the reset.sql file once the first module ends (which should be at the end of day three).
4. This script requires the instructor to know the sid and the number of accounts to be reset. The instructor is prompted for this information.
5. All users must be disconnected from the session in order for the reset scripts to work.
6. The script is run from SQL*Plus and the working directory in SQL*Plus must be set to the \labs\reset folder.
7. Once the information is provided, the accounts are automatically rebuilt for the second module.
8. To test the account, issue the following SQL statement from one of the reset accounts:
SELECT COUNT(*) FROM employees;
==========================================================
You may have to uncomment lines in the reset script.
==========================================================
Would you also check that underneath the student and instr folders on the C drive there are folders for both parts of the class SQL1 and SQL2. Also have a student check that they have a folder for SQL2 in addition to SQL1. Thanks.
Byron Rendar
PCC Computer Education Program