How To Install Scott Schema In Oracle 11g

Scott schema is the most famous oracle database demo schema that is bachelor since 1990 !.

Scott is a database user used for demonstration purposes containing the famous EMP, DEPT, BONUS and SALGRADE tables.
This business relationship was named afterBruce Scott (co-author and co-architect of Oracle v1 to v3) and the countersign was the name of his daughter's cat,Tiger.

Scott schema is all the same very famous although of the other demo schemas (hr, oe, pm, nine, sh ,bi) that I explained how to install them in my previous post:
https://ahmedfattah.com/2019/12/23/installing-oracle-sample-schemas-19-iii/

The scott schema contains four tables:

How to Install Scott Schema?

Oracle provides a script since the very early releases to create the scott schema. The script is called "scott.sql" and is located under $ORACLE_HOME/rdbms/admin.
The last time this script was updated is at 28-Jun-1995 !.
This script is withal available in all the Oracle latest releases: 12.1 , 12.2 , 18c & 19.3.

The script is simply creates the scott user with password tiger, and and so creates 4 tables and insert information into them.

To run the script and create the scott demo schema:
sqlplus / as sysdba
@?/rdbms/admin/scott.sql

In the following demo, I'k going to create the scott schema into a 19.3 pluggable database called "pdb1".
Also, I modified line # 27 in the scott.sql script from:
CONNECT SCOTT/TIGER
to:
CONNECT SCOTT/TIGER@//localhost:1523/pdb1

That is all, now we accept fully functional scott schema.
You tin can run the aforementioned script any number of times, it volition drib the existing tables first, then creates a new copy.

Cheers
Ahmed

Donate to support our blogging work

$1.00

Source: https://ahmedfattah.com/2019/12/24/creating-scott-sample-database-schema/

Posted by: haagsaider.blogspot.com

Share this post