About ORACLE_HOME

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: the meaning and purpose of ORACLE_HOME how to check if ORACLE_HOME is set how to […]

Read the Full Article →

Oracle 10G Express Edition

Oracle Database 10g 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 XE is just the answer for you. This starter version of Oracle is free to download, distribute and deploy. […]

Read the Full Article →

SCOTT schema in Oracle

What is SCOTT? Scott is a database user 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 like HR and OE are available that are more suited for demoing newer Oracle features. How to install […]

Read the Full Article →