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: Click here

• 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:

              @(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.

• 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:
http://www.youtube.com/watch?v=vHcAs7k93AQ

No comments

Posted at 09:06 |  by Pritam

How to Install and Configure Oracle Database 11g Release 2

Welcome to the tutorial series of ORACLE DATABASE 11G Release 2 . Here i am pritam kumar , will guide you on different topics you need to learn about ORACLE DATABASE 11G Release 2. I am putting my whole effort in making this series a learn-able one for beginners who i assume dont have any idea about this .

In this video the complete installation process of Oracle Database 11g R2 is shown . I have made it from the very beg ginning .Starting from downloading the software from the official website of Oracle up to Installing  all the required things. Just do the steps shown in the video and  install the oracle database on your windows OS.Make sure that you are following my steps and not skipping anything , because in some  part if  you miss a step then the installation may show you some errors and will again ask you to install from the beginning .

While  installing the oracle database , it  should create a database automatically after the installation of the software but if some error occurs then it will not create the database . Then you have to make the database manually which i have shown you on the video , I have tried to cover all the context required but if i missed anything or you do have any questions feel free to contact us by putting a comment below the video.

Download the software from:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

No comments

Posted at 08:56 |  by Pritam

Introduction to Oracle Database 11g 1Z0 015 SQL Fundamentals 1

A Complete Tutorial Series on Oracle 11g , SQL Quries,Basic Fundamentals on Database and all the related Topics.

If you want any details you can contact us here by putting a comment below this video.

No comments

Posted at 08:50 |  by Pritam