In order to follow and practice examples of this tutorial, you need to create a user named iself with all its necessary tables.

There is a script named "create_tables.sql" at your CD located in the "iscdxx\iss" sub-directory.

This Hands-On shows you how you can run the script to create a user named "iself" with password "schooling" and all its tables.

Go to MS-DOS and login to "sqlplus" as system/manager.

Run the "create_tables" script located on the "iss" folder on your CD.

This script creates the "iself" user with password "schooling."

Then, creates its tables and inserts records into each table.

You should use the "iself" userid to do the Hands-On exercises.

Once the job is finished, connect as "iself" with password "schooling" to make sure that the user and its tables were created.

=

Done.

Now, connect as "iself” password “schooling."

Query all its tables.

There should be eleven tables.

It looks Okay.

Exit “sqlplus.”

Exit windows.

===

Then, check the log file in your C: drive.

Open Windows Explorer."

Go to the “C:” drive and open the "create_tables" log file.

===

Ignore the first error but, there should be no other errors after that.

Once you have created the “iself” schema, you should be able to follow all the Hands-On exercises.

Good luck.