Oracle Scott Schema

This is Oracle's famous Scott/Tiger demo schema, created by Bruce Scott, Oracle employee number 4, co-author of Oracle V1 - V3. Tiger was the name of a cat belonging to Bruce's daughter.

Download Apps Demo
Download Scott Schema DDL

To install the Scott demo schema:

  1. Download Oracle Database.
    Download Oracle

  2. Extract the installation files from the Zip archive.

  3. Run setup.exe to install Oracle database.

  4. Right-click on the download icon, select Save link as, and save the install_scott_schema.sql file to your computer.
    Download Scott DDL

  5. Open the Command Prompt.

  6. Change directory to the location where you downloaded install_scott_schema.sql

  7. Run SQL*Plus, as a user with system privileges.
    SQLPLUS / AS SYSDBA

  8. Run the installation script:
    @install_scott_schema



Home