Here are the steps to create the necessary schema and tables for the SQL class labs:

1) Make sure that your ORCL database is up and running and you can connect to the database by checking your Services under Administrative Tools in the Control Panel. Look for services that start with the phrase “Oracle” and make sure the listener and ORCL services are started.

2) Download the setup files from the downloads link on the course home page in VISTA. Unzip these files into a folder.

3) Create a folder called scripts at the root level of your c: drive

4) Copy all of the scripts that you unzipped in step 2 file into the new scripts directory. 

5) Open up SQL*Plus. Login as sys/oracle as sysdba (that is sys with a password of oracle using the role sysdba)

6) Run the script setup1.sql.  by typing in   ‘@c:\scripts\setup1.sql;’ on the command line in SQL*Plus. This script creates 20 user accounts with the names ora1 through ora20 with the same password as the account/schema name.

7) Log in as ora1 with the password ora1

8) Check out the tables that were created for you:

select table_name from user_tables;