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: https://github.com/oracle/db-sample-schemas/releases Extract the files: Extract the file “db-sample-schemas-21.1.zip” 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: https://www.youtube.com/watch?v=ZRodqYAUxtk 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:https://ahmedfattah.com/2019/12/25/how-to-create-the-scott-oracle-database-demo-schema/ Here is a live demo about Order Entry (OE) schema installation: https://www.youtube.com/watch?v=c8dxF-1rGZo Please note that before installing the OE schema, you should first install … Continue reading Installing Oracle OE Sample Schema