In Oracle installation guides and scripts, you will often come across the term ORACLE_HOME. In fact, we used it on this site a couple of posts back, in the script to install SCOTT schema in Oracle.
This post will cover:
Oracle Database Express Edition (Oracle Database XE) is a free, lightweight version of Oracle.
If you’re a small enterprise with modest database needs, or an individual looking to learn Oracle on your home computer, Oracle Express Edition is just the answer for you.
This starter version of Oracle is free to download, distribute and deploy. It supports up to 4GB of user data, in addition to Oracle system data.
A demo database called HR is provided with the installation.
SCOTT is a database schema in Oracle, used for demos and examples.
The SCOTT schema used to be installed by default in earlier versions of Oracle. Not anymore. Oracle 9i onwards, new sample schemas such as HR and OE are available that are more suited for demoing newer Oracle features.
You might still want to have the SCOTT schema in the database, for trying out examples from old manuals, or maybe because you’ve used it so much it’s like an old friend.
Good news – there’s a script to do the installation with a single command. Here’s how: