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

-

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.

For More Usefull Post's...!!
Follow me On Facebook       :  Arshman Saleem

Subscribe me On Facebook :  Computer Programming Assignment's

Follow me On Twitter            :  @Arxhman