Appendix F: Installing the ACME Database - SQL Bible [Electronic resources] نسخه متنی

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.