iSelfSchooling.com - Since 1999  References  |  Job Openings  |  Post Notes
    Home  | Search more  | Oracle Syntax  | Computer Institute   | (Login or Register to access to all VIDEOS)
 

Copyright & User Agreement

   Suggestions Email2aFriendHomepage us! |  Bookmark

Services

  Vision/Mission

  Services

  Biography

  Contact Us

  Post Notes

 FREE Training

  Start...

  SQL

  PL/SQL

  Forms 

  Reports

  DBA Fundamentals

  Performance

  Prepare for OCP

...

  Acknowledgement

  Who is who

  University Directory

  Links...

 

 

 

Topics:  iself schema

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.

 

More Resources by Google:

Manuscript

 

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.

 

 
 
Google
 
Web web site