To run this script you need to:
(i) Load Oracle on your computer
(ii) Download the above "Load" script and save it in your Oracle/Bin directory. To download the script, RIGHT click on "The Load Script", select SAVE LINK AS and leave the name of the script file as "load_all2.sql".
(iii) Log on to Oracle as the system manager (Userid: system; Password: manager)
(iv) To run the "load_all2 script", type the following at the SQL prompt:
SQL>@load_all2
You will be prompted twice for a user name for yourself. The way the script is set up, your username and userid will be the same. After you finish the load, type exit from the SQL prompt, exit Oracle, and then sign on to Oracle as yourself (your_username/your_username).
This script needs to be loaded only once into Oracle's bin directory. The script, however, can be run over and over as it deletes the old tablespaces, tables, users and other objects.
As you run the script, if you get any error messages, just ignore them. The error messages come up because it is trying to delete old tablespaces, tables and other objects, which you do not have in the first place when you are running the script for the first time. Just type in your username when it asks you for your "uname", hit <Enter> and keep going. The script should not take you more than a couple minutes to load. When the loading is done, you will automatically be at the SQL prompt.