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 (5452) (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. :)

Subscribe

Subscribe to our email feed and never miss a post

Join Us