logo

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 Express.
    Download Oracle XE

  2. Follow the instructions in the installation guide.
    XE Installation Guide

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

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

  5. Run the installation script:
    @install_scott_schema



Home