|
In order to follow and practice examples of this
tutorial, you need to create a user named oracle
with all its necessary tables.
There is a script named "create_tables.sql"
download it here.
This Hands-On shows you how you can run the script
to create a user named "oracle" with password
"learning" and all its tables.
Go to MS-DOS and login to "sqlplus" as
system/manager.
Run the "create_tables" script you downloaded above.
This script creates the "oracle" user with password
"learning."
Then, creates its tables and inserts records into
each table.
You should use the "oracle" userid to do the
Hands-On exercises.
Once the job is finished, connect as "oracle" with
password "learning" to make sure that the user and
its tables were created.
=
Done.
Now, connect as "oracle� password �learning."
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 �oracle� schema, you
should be able to follow all the Hands-On exercises.
Good luck. |
