To drop the account that owns the database objects you need to perform the following actions:
1. Download the script DROP_USER.SQL and save it in your environment, for example in the folder C:\ORAFORMS_BOOK\SQL.
2. Obtain SYSTEM access to the Oracle Server instance where the account that owns the objects of this book was created.
3. Start SQL*Plus and connect to the Oracle Server instance.
4. At the SQL prompt type START <path>\DROP_USER.SQL and press ENTER. Here, <path> is the location where you saved the file DROP_USER.SQL. For example:
START
C:\ORAFORMS_BOOK\SQL\DROP_USER.SQL
5. Provide the password for the account SYSTEM when prompted.
6. Provide the database name or connection string when prompted.
7. Provide the name of the user you want to drop when prompted. Be very careful you provide the correct account name, since the action of dropping the account cannot be reversed.
At this point, the script drops the account and all the associated objects. The following listing is a sample log of the prompts, input and output you should expect when running the script.
SQL> start d:\formsdisk\sql\drop_user.sql
Please enter password for user SYSTEM :
*******
Enter database name or connection
string. Default is [LOCAL] : tstliv
Connected.
Enter new user name: oraforms
User dropped.