Oracle 10g XE – Creating scott schema & default tables


There is no Oracle default scott schema or default tables like emp,dept,bonus,salgarde in Oracle 10g XE. Here is a easy step by step by guide to create it.

1) Download & install Oracle 10g XE.

2) Go to Start > All Programs > Oracle Database 10g Express Edition > Go To Database Home Page

3) Log in using username: system & your password you entered in installation process

4) Go to Administration > Manage Database Users > Create

5) username: scott Direct Grant System Privileges: CREATE TABLE (You can modify these settings later)

6) Go to Start > All Programs > Oracle Database 10g Express Edition > Run SQL Command Line

7) type connect

8) username: scott password: password you entered in step 5

9) Download this file oracle default tables (6798) (this contents data for the tables)

10) extract the downloaded file

11) type this command in sql command prompt


replace yourfilepathhere with the path of the sql file you just extracted. here is an example


12) You are done!!! Now you can work with scott schema & all oracle default tables

Enjoyed this article? Share with friends

  • Srinivas

    useful buddy………..

  • Praveen Pandey

    Thanks :)

  • Bikram Nayak

    getting error
    “unable to open file

    • Make sure your path to sql file is correct and you have required permission for that file

  • rakesh

    hi i need to load the default emp ,dept tables how ?

  • Rajpal Singh

    Working fine. :)

  • chandrahas

    SQL*Plus: Release – Production on Sat Feb 11 12:50:59 2017

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> conn hr/hr;


    ORA-28000: the account is locked

    SQL> conn system/system;


    SQL> @C:UsersChandrahas KondleDownloadsoracleoracle.sql

    SP2-0310: unable to open file “C:UsersChandrahas.sql”

    SQL> @C:UsersChandrahas KondleDownloadsoracleoracle.sql;

    SP2-0310: unable to open file “C:UsersChandrahas.sql”

    SQL> @C:UsersChandrahas KondleDesktoporacle.sql

    SP2-0310: unable to open file “C:UsersChandrahas.sql”


  • Hassan

    Error: “Unable to open file”
    File path is correct also have permissions


Subscribe to our email feed and never miss a post

Join Us