Monday, October 26, 2020
dbametrix
More
    Home Technology Why Scott becomes default schema in Oracle?

    Why Scott becomes default schema in Oracle?

    Hi ALL,

    As Oracle DBA we are familer with SCOTT schema. This schema is default sample and example schema which is available since past several  years.

    - Advertisement -
    dbametrix

    Why this SCOTT schema still persists?

    Do you guess any reason?

    Who is  SCOTT?

    Actualy beginner of  SQL*Plus was Bruce Scott. He was original auther of SQL*Plus.  In the memory of Bruce Scott, a sample schema named “scott” has been created in Oracle database with set of example tables for learning purpose.  There are famous tables like EMP, DEPT, SALGRADE , BONUS.

    - Advertisement -
    dbametrix

    Password of Scott schema is “tiger” coming from his daughter’s cat name. His daughter’s cat name was “tiger”.

    Bruce Scott was the first employee of Oracle Corporation. Due to these reasons Oracle Corporation still use default sample schema named “SCOTT” and password of same schema as “tiger” .

    Thanks and Regards,

    Gitesh Trivedi

    [email protected]

    http://www.dbametrix.com

    - Advertisement -
    dbametrix
    Previous articleAbout
    Next articleSQL a History

    3 COMMENTS

    Comments are closed.

    - Advertisment -
    dbametrix

    Most Popular

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Differences Raw Device, ASM Device and CFS

    The article explains basic differences of ASM device, raw device and Oracle cluster file system cfs with fundamentals

    Recent Comments