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

 

1)  Create a tablespace called data01 inside your ORCL database (new Oracle 10g database created by the universal installer) with 80MB of storage.

            - Open up SQL*Plus

            - type the following in the username section:  sys/oracle as sysdba

            - hit enter

            - issue the following SQL command: create tablespace data01 datafile 'data01.dbf' size 80m autoextend on;

 

2) Make sure the system user account is unlocked and change the password to manager:

            alter user system identified by manager account unlock;

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

4) Copy all of the scripts that are in the createschema.zip file into that directory.  Click on this link to download the createschema.zip file.

5) Open up SQL*Plus. Login as system/manager as sysdba.

6) Run the script creschem.sql.  Pass it the number of accounts you want created.  Create 2:

            @c:\scripts\creschem.sql 2

7) Log in as ora1 with the password oracle  (the password may be different if you used a different password for your sys user).

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

            select table_name from user_tables;