remote dba support
More
    HomeTechnologyWhy 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

    https://www.dbametrix.com

    When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.

    This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.

    - Advertisement -
    dbametrix
    Previous article
    Next article

    3 COMMENTS

    Comments are closed.

    - Advertisment -
    remote dba services

    Most Popular