Databases Reference
In-Depth Information
See also
F
Acquiring data using Data dictionary and dynamic performance views
recipes in
this chapter
F
Appendix B
,
Tools and Packages
Exploring the example database
In this recipe, we will prepare a database to use for our examples.
Getting ready
We need an Oracle Database 11
g
R2 system up and running to create our database. The
host system could be a UNIX/Linux or Windows physical or virtual machine. If you want to
use a virtual machine, be sure to follow the minimum CPU and memory requirements for
the Oracle installation.
If you have installed the database software along with the Create Database option, then
you have already set up a database with the necessary schema installed.
How to do it...
We will use the default demo database installed by the default OLTP template of Oracle
Database Configuration Assistant (DBCA) for all our examples.
You can find the official Oracle Database Installation Guide 11
g
R2 for
install.112/e16763/toc
.htm
.
1.
Log on to the Operating System as a member of the administrative group, authorized
to install Oracle software and to create and run database instances.
2.
Launch DBCA (for Windows users: Start | Programs | Oracle - home_name |
Configuration and Migration Tools | Database Configuration Assistant) for
*nix systems enter the following command at system prompt:
$ dbca
Please note that the
dbca
executable is by default in the
$ORACLE_HOME/
bin
directory.
3. A welcome screen is shown. Click Next.
4. You are presented with some options. Select the first, namely Create a database,
and click Next.
