Oracle 10g XE – Creating scott schema & default tables

ORACLE 10G XE

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 (6624) (this contents data for the tables)

10) extract the downloaded file

11) type this command in sql command prompt

@(yourfilepathhere)/oracle.sql;

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

@c://downloads/compressed/oracle/oracle.sql;

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 10.2.0.1.0 – Production on Sat Feb 11 12:50:59 2017

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

    SQL> conn hr/hr;

    ERROR:

    ORA-28000: the account is locked

    SQL> conn system/system;

    Connected.

    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”

    SQL>

  • Hassan

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

Subscribe

Subscribe to our email feed and never miss a post

Join Us