Oracle
Unlike many of the databases in this appendix, particularly the
Java-based ones such as InstantDB and Cloudscape, creating a new
database with Oracle is not such a trivial
matter. In fact, entire books have been written about configuration
and maintenance of Oracle databases! So in this section, the
assumption is made that the database has already been created and set
up. The global name of the database is
ftht.middleearth.com
(“ftht” instead of
“forethought” because there is an
eight-character limit on global names, and
“middleearth.com” because
it’s my home network’s domain), and
the SID is FTHT. Other than these basic
parameters, specific configuration items like rollback sizes and
TEMP tablespaces are left to you or your DBA.
Additionally, the examples shown assume that a user has been created
in the database, with the username
“forethought” and the password
“forethought”. This user (for
simplicity’s sake) has been given the role
DBA. This makes connecting, creating tables, and
other administrative duties possible without explicitly granting many
permissions (like CREATE SESSION,
ALTER ANY TABLE, etc.).
Deployment and execution of SQL scripts in Oracle is usually done through the use of the Oracle SQL*Plus tool, with the database to modify up and running. You connect as the user able to administrate the database schema; here the user “forethought” is used. You should be in the directory where the SQL scripts you want to execute are located.
Each SQL script can be run ...