Appendix F: Installing the ACME Database

This appendix explains how to install the sample ACME database on the RDBMS of your choice. Refer to the section that corresponds to the database platform you've created.

Installing the ACME Sample Database on Oracle 9i (Windows) Using SQL*Plus

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

If the Oracle services are not started, start them as described in Appendix D.

Copy the D:\sqlbib\oracle_acme (where D is the letter of your CD-ROM drive) directory from the CD-ROM that comes with your book to the C:\ directory of your computer.

Start SQL*Plus from the command line by typing:

C:\> sqlplus
/nolog

If you want to create a 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, the other files you need are:

SQL> spool
C:\sqlbib\oracle_acme\load.log

Run script C:\sqlbib\oracle_acme\load.sql:

SQL>
@C:\sqlbib\oracle_acme\load.sql

This script creates the Oracle ACME database. Stop spooling (if started) by issuing:

SQL> spool
off

Type quit to exit SQL*Plus.