Installing Oracle Database Sample Schemas (21c)

In this post, I’m going to explain how to install Oracle database sample schemas on Oracle database version 21c. Download the Scripts: Starting from Oracle database 12.2 ,the sample schemas setup scripts are now available from GitHub. Pick the release that matches your database release: Extract the files: Extract the file “” directly into $ORACLE_HOME/demo/schema, … Continue reading Installing Oracle Database Sample Schemas (21c)


Installing SH Sample Schema

Preparation: Before running the installation script (sh_main.sql), please edit the following two files:sh_main.sql & sh_olp_c.sqlunder D:\app\db193\WINDOWS.X64_193000_db_home\demo\schema\sales_history and replace "__SUB__CWD__" with "D:\app\db193\WINDOWS.X64_193000_db_home\demo\schema" or the directory where you extracted the sample schema scripts. Here is a live demo about installation: ThanksAhmed

Installing Oracle OE Sample Schema

If you are interested in installing all oracle database sample schemas, please refer to my post:Installing Oracle Sample Schemas (19.3) If you want to install the scott demo schema, please refer to: Here is a live demo about Order Entry (OE) schema installation: Please note that before installing the OE schema, you should first install … Continue reading Installing Oracle OE Sample Schema