SQL Bible [Electronic resources] نسخه متنی

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).

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

# echo $ORACLE_SID ACME
#

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.

Start SQL*Plus from your home directory by typing:

# sqlplus
/nolog

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

Run the script
sqlbib/oracle_acme/load.sql:

SQL>
@sqlbib/oracle_acme/load.sql

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

SQL> spool
off

Type
quit to exit SQL*Plus.