-
How to Create SCOTT Schema and default tables in Oracle Database 11g
Written By Arshman Saleem
Watch this Complete Tutorial for Create Scott Schema
(If Any Query about this article then you can contact Arshman)
If there is no Oracle default 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 in database. Here is
the easy step by step tutorial to create in your database.
- Open the SQL Plus/SQL Command Prompt 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 Scot Schema.
- Run this Script.
Create User Scott Identified By tiger;
Scott the user
Tiger is the password.
Grant all access to user Scott, run this Script.
Grant all Privileges to Scott;
Download the Oracle Default Table File.
Extract the download file in your system.
Then Connect to Scott user as
Connect Scott
Password : Tiger
Then Type this your SQL Command Prompt.
@(Extract file path)\Oracle.Sql;
For Example:
@C:\Users\ABC\oracle\oracle.sql;
Now you done all the steps completely and you can work
with Scott Schema and all the default tables.
Follow me On Twitter : @Arxhman
