How to Create SCOTT Schema and default tables in Oracle Database 11g

If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database.

Open the sql plus in your system.

Login as username : sys as sysdba and the password which is given at the time of installation.

After connected to Oracle database you need to create the scott schema.

Run this script:
CREATE USER scott IDENTIFIED BY tiger;

scott is the user
tiger is the password.

Grant all access to user scott,run this script:
GRANT ALL PRIVILEGES TO scott;

Download the Oracle default tables file:

Extract the downloaded file in your system.

Then Connect to Scott user as:
CONNECT scott

Password: tiger

Then type this in your sql command prompt:
for example:

Now you done all the steps completely and you can work with scott schema and all the default tables.

Check This in your system to show all the tables in scott user:
Select * from tab;

After that you can see all the default table in scott user.
Just run it to show the default data inside the tables.
Select * from emp;

If 14 row selected....Then You sucessfully Created the scott schema and the default Oracle tables in your
system.

Like and subscribe this video:

[dhananjayapandau]

thanku sir i helped a lot it really works 100%

[satyamshubhamjena]

Thank You sir for more informative video

[shashank]

if some one having problem like invalid sql statements then follow the steps
step 1 =
Paste the oracle file into local disk C only if you paste another place it wont work
step 2 =
open sql write
connec scott/tiger
@C:\oracle.sql ;
then it successfully works open the any of the table like emp, dept, salgrade
select * from emp ; to check

[krismaly]

I couldn't find 
Oracle default tables file in the website
could you please clarify?

[elionushi]

Hi, when I type "create user scott identified by tiger;" it displays an error saying : ORA-65096: invalid common user or role name, what should I do ?

[TarunKumar-obme]

Hello, while applying path on sql cmd line it showing invalid sql statements what should i do for that?

[mdshelimuzzaman]

when I write CREATE USER scott IDENTIFIED BY tiger and run I get a message saying user name 'SCOTT' conflicts with another user or role name, how can I get rid of this? Thanks

[rosachoquepataturpo]

Mi amigo me hablo en brasileño y me explico eso y despues me dijo q' lo saco de tu video xdd

[arnabjyotikalita]

the site u shared (i.e. webdesignfreetutorials.in) in this video does not work...

[sanjeetroy]

EMPNO ENAME and DEPTNO. all are overlap ....not good.

[youlearned]

file is not opening where to download the file

[ravindrachowdary]

hi please help me
while i am typing select* tab it shows table or view does not exit how to get tables in oracle 11g express edition?