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.
Following are instructions on how to install the ACME sample database on Oracle 11g using the SQL*Plus utility (explained in Appendix E, "Accessing RDBMS").
Start your Oracle instance. Make sure that your session's
ORACLE_SID environment variable points to the correct instance:
# echo $ORACLE_SID ACME #
Create your directory:
Download corresponding scripts from the accompanying SQL Bible website to the directory you created.
Change your current directory to
/home/oracle/sqlbib/oracle_acme and start SQL*Plus by typing the following:
# sqlplus /nolog
If you want to create the log file, use the
spool command (described in Appendix E, "Accessing RDBMS"). 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 load.log
This script creates your Oracle ACME database. Stop spooling (if started) by issuing the following command:
SQL> spool off
quit to exit SQL*Plus.
Check the file
load.log for possible errors.