HomeОбразованиеRelated VideosMore From: variabletips

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

53 ratings | 17628 views
Looking for a best Webhosting Company at low and Best Service click this link:https://www.ipage.com/join/index.bml?AffID=739220 From Last Few Months I Was Looking For Best Webshosting Company Where I Can Host My 100 Of Website At Low Price And With Best Quality Service , And Then I Came To Know About https://www.ipage.com/join/index.bml?AffID=739220 A Hosting Company Where I Get Hosting For Unlimited Domains At Just 1.6$ Per Month With Control Panel , 24hrs Support And All In All A Best Platform To Host Any Website( one-click install wordpress option) .Dont Be Late Offer Valid Till 25th October 2014 , Host Your WebSite With Best Service Provider Today By Clicking The Link Above Or Here: https://www.ipage.com/join/index.bml?AffID=739220 To get a responsive and Modern design contact http://www.variabletips.com and get at just 20$ Now !!! Check my Website: http://variabletips.com for more details. 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: https://www.dropbox.com/s/m9lr8cnc00vqy3i/oracle.zip https://drive.google.com/file/d/0BxJYa0O21A_udlZqQmNZaFBvNTA/edit?usp=sharing 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
Html code for embedding videos on your blog
Text Comments (41)
Shashank parmar (1 month ago)
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
Rajesh das (1 month ago)
Thanks dear
Sanjeet Kumar (9 months ago)
EMPNO ENAME and DEPTNO. all are overlap ....not good.
Veerabommu Mahesh (1 year ago)
Tq bro
Rajesh kumar (1 year ago)
Thank u
Manjunath N P (1 year ago)
Thanks! it helped.
Md Kamran (1 year ago)
thanks a million.
Linh Hoàng (1 year ago)
thank you very much
variabletips (1 year ago)
Thanks keep watching , if any technical question you have feel free to ask :-)
Cyber Insight (2 years ago)
thanku sir ........................ i helped a lot ...... it really works 100%
Sayantan Ghosh (3 years ago)
Thanks buddy.....
Raveendra Bharadwaj (3 years ago)
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?
Elio Nushi (3 years ago)
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 ?
Tarun Kumar (3 years ago)
Hello,while applying path on sql cmd line it showing invalid sql statements what should i do for that?
Shashank parmar (1 month ago)
Paste in C folder then write @C:\oracle.sql then it works
Sabyasachi Mishra (3 years ago)
thank u sr,,,,it works nice....
sravani garlapati (3 years ago)
i couldnt open the link www.webdesignsfreetutorials.in  pls help me out on this sir.. i need it very urgently
variabletips (3 years ago)
+sravani garlapati actuall the site is down for some maintenance issue you can ask what you need here..
Hari Prasad Pannuri (3 years ago)
Thank you dude .. I got it
sridhar k (3 years ago)
Thanks a lot. This worked for me!
Akshaya Kumar dash (3 years ago)
file is not opening where to download the file
Akshaya Kumar dash (3 years ago)
+Variable Tips i have already done it
variabletips (3 years ago)
+Akshaya Kumar dash https://drive.google.com/file/d/0BxJYa0O21A_udlZqQmNZaFBvNTA go to this link on description .
Rishiraj Sengupta (4 years ago)
After extracting the database tables in c drive and connecting using scott and tiger ,I typed @c,the sql command line shows unable to open file "@c.sql" and after typing @c:\oracle.sql it is again telling unable to open file c:\oracle.sql  what should I do?
Azhar Khan (4 years ago)
+Rishiraj Sengupta i have the same error. unable to open the file.. please help Variable tips/..
Jessy Saby (4 years ago)
Thank you very much
Kris Maly (4 years ago)
Good introduction  Thanks a lot
Kris Maly (4 years ago)
I couldn't find  Oracle default tables file in the website could you please clarify?
Arnabjyoti Kalita (4 years ago)
the site u shared (i.e. webdesignfreetutorials.in) in this video does not work...
variabletips (4 years ago)
+gangabhavani nalluri  what does not work nalluri?
gangabhavani nalluri (4 years ago)
+Variable Tips this vedio also does not work
variabletips (4 years ago)
The new website is : http://www.variabletips.com..i could not get time to update the info with new website.
ranjit nayak (4 years ago)
hello thanks for posted this video...
variabletips (4 years ago)
+ranjit nayak keep watching our videos and if you need any type of Website design help or development let us know we will be happy to help you.
sleepySLEEPYLOL (4 years ago)
hey man! Thanks alot for the default files! This worked for me! Keep it up, Variable Tips.
variabletips (4 years ago)
+lvde21 keep watching our videos and if you need any type of Website design help or development let us know we will be happy to help you.
Akshay Sawant (5 years ago)
variabletips (4 years ago)
+Akshay Sawant keep watching our videos and if you need any type of Website design help or development let us know we will be happy to help you.
Md Shelimuzzaman (5 years ago)
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
variabletips (4 years ago)
+Variable Tips keep watching our videos and if you need any type of Website design help or development let us know we will be happy to help you.
variabletips (5 years ago)
In your database the user SCOTT is already created , so no need to create the same user again , if you want to create another user , then give another name and password you  desire. If you dont find any default table inside the SCOTT user then download the orcle.sql file form the link in the description then execute it . I think this is what you are looking for.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.