4 Install Sample Database/Schema for Oracle 11gR2

I want to install the sample database for my Oracle database server.

Prerequisite

Oracle Database installed. You can refer here for installing the Oracle Database.

Software

• Oracle Database Example

 

Install the Oracle Example

the 11.2.0 installer does not recognize the newer version of package therefore, if the system already has the newer version of the packages, it can be ignore.

After the installer completed, the mksample.sql script is populate to under $ORACLEHOME/demo/schema directory. We can use it to create the sample schema.

Install the Sample Schema

I am going to use the mksample.sql to create the sample schema. This is the primary script and will invoke other script to create the correspond schema. If only need some schema, you can just invoke the individual script. For example, the HR schema can be created by invoking hr_main.sql under human_resources folder.

 

@$ORACLE_HOME/demo/schema/mksample.sql

 

The log file path must be end with / .

After scripts, we can exam the log file in the log directory to see if there is any error.

 

 

Reference

• http://docs.oracle.com/cd/E11882_01/server.112/e10831/scripts.htm