In this recipe, we will prepare a database to use for our examples.
We need an Oracle Database 11gR2 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.
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 ...