Installing the ACME Database on Oracle 9i (UnixLinux) Using SQLPlus

Installing the ACME Database on Oracle 9i (Unix/Linux) Using SQL*Plus

Following are instructions on how to install ACME sample database on Oracle 9i (Unix/Linux) using the SQL*Plus utility (explained in Appendix E).

1. Start your Oracle instance. Make sure that your session's ORACLE_HOME environment variable points to the correct instance:

   # echo $ORACLE_SID ACME  #

   Cross-References 

   The Unix/Linux Environment Variables required to run sqlplus utility are listed in Table D-3 and Table D-5 of Appendix D.

2. Insert the book's CD-ROM into your CD-ROM drive. Mount the CD-ROM and copy the /sqlbib/oracle_acme directory from the CD to your home directory.

3. Start SQL*Plus from your home directory by typing:

   # sqlplus  /nolog

4. If you want to create the log file, use the spool command (described in Appendix E). For example, if you want the resulting log file load.log to be created in the same directory as your other files, type:

   SQL> spool  sqlbib/oracle_acme/load.log

5. Run the script sqlbib/oracle_acme/load.sql:

   SQL>  @sqlbib/oracle_acme/load.sql

6. This script creates your Oracle ACME database. Stop spooling (if started) by issuing

   SQL> spool  off

7. Type quit to exit SQL*Plus.

   Note 

   Script  load.sql runs two other scripts,  create_acme_ora.sql and  load_data_ora.dat. The first one creates RDBMS objects (tables, indexes, constraints, views, and so on) and the second script populates ACME tables with data. You may want to run the first script by itself before trying the examples from Chapter 6. You can run  load.sql and  create_acme_ora.sql as many times as you want to create a loaded or empty ACME database, correspondingly.