 |
|
12-15-2006, 09:55 PM
|
#1 |
|
Team Leader
 
Join Date: Apr 2005
Location: Kolkata, India
Posts: 1,461
Thanks: 0
Thanked 19 Times in 16 Posts
Rep Power: 6   |
The Mystery of Scott/Tiger in Oracle
You must have always wondered why there is a uname / pwd in Oracle called, Scott/Tiger.... Who is this scott ? Here is the answer to ur query.... So, who is Scott? Bruce Scott was one of the first employees at Oracle (then Software Development Laboratories). He co-founded Gupta Technology (now known as Centura Software) in 1984 with Umang Gupta, and later became CEO and founder of PointBase, Inc. Bruce was co-author and co-architect of Oracle V1, V2 and V3. The SCOTT schema (EMP and DEPT tables), with password TIGER, was created by him. Tiger was the name of his cat.
__________________
Vote for the Most Entertaining Member of 2008 To err is human,to detect is divine! |
|
|
|
12-18-2006, 10:58 AM
|
#2 |
|
Team Leader
Join Date: Jul 2004
Posts: 436
Thanks: 0
Thanked 5 Times in 3 Posts
Rep Power: 6 |
Re: The Mystery of Scott/Tiger in Oracle
Thats a nice peace of info.
|
|
|
|
|
07-26-2009, 09:28 PM
|
#3 |
|
Go4Expert Member
Join Date: Jun 2009
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0 |
Re: The Mystery of Scott/Tiger in Oracle
very nice,,.
|
|
|
|
|
07-26-2009, 11:56 PM
|
#4 |
|
Mentor
 Join Date: Aug 2004
Posts: 1,770
Thanks: 2
Thanked 45 Times in 36 Posts
Rep Power: 10 |
Re: The Mystery of Scott/Tiger in Oracle
It's only there if you select it at install time. Having a user called scott is by no means compulsory.
|
|
|
|
|
07-27-2009, 01:51 AM
|
#5 |
|
Invasive contributor
 
Join Date: Jun 2009
Location: Pune,Delhi
Posts: 799
Thanks: 87
Thanked 75 Times in 55 Posts
Rep Power: 2 |
Re: The Mystery of Scott/Tiger in Oracle
nice.... been wondering this for quite long  In college we enter Scott/Tiger/Infotech any idea why infotech...or is it set by our college? |
|
|
|
|
07-27-2009, 01:51 AM
|
#6 |
|
Invasive contributor
Join Date: Jun 2009
Location: Pune,Delhi
Posts: 799
Thanks: 87
Thanked 75 Times in 55 Posts
Rep Power: 2 |
Re: The Mystery of Scott/Tiger in Oracle
nice.... been wondering this for quite long In college we enter Scott/Tiger/Infotech any idea why infotech...or is it set by our college? |
|
|
|
|
07-27-2009, 01:59 AM
|
#7 |
|
Mentor
Join Date: Aug 2004
Posts: 1,770
Thanks: 2
Thanked 45 Times in 36 Posts
Rep Power: 10 |
Re: The Mystery of Scott/Tiger in Oracle
Is it scott/tiger/infotech or scott/tiger@infotech? If @ then that's the database alias - you're connecting in a client/server configuration and infotech is defined in $ORACLE_HOME/network/admin/tnsnames.ora. Another way to do the same thing would be to set the environment variable TWO_TASK=infotech, then sqlplus scott/tiger would do the same thing. If scott/tiger/infotech, no idea, never seen that syntax before, unless the password is "tiger/infotech". |
|
|
|
|
07-27-2009, 02:21 AM
|
#8 |
|
Invasive contributor
Join Date: Jun 2009
Location: Pune,Delhi
Posts: 799
Thanks: 87
Thanked 75 Times in 55 Posts
Rep Power: 2 |
Re: The Mystery of Scott/Tiger in Oracle
@xp its @ and what i asked was like scott tiger, is infotech come pre installed? if yes any reasons like above? |
|
|
|
|
07-27-2009, 02:53 AM
|
#9 |
|
Mentor
Join Date: Aug 2004
Posts: 1,770
Thanks: 2
Thanked 45 Times in 36 Posts
Rep Power: 10 |
Re: The Mystery of Scott/Tiger in Oracle
No, infotech will have been setup by your sys admin. Have a look at tnsnames.ora and you'll see how it's defined, not much of any interest in there though. The scott schema doesn't come pre-installed; you have to select it in the installer. |
|
|
|
|
07-28-2009, 02:12 AM
|
#10 | |
|
Invasive contributor
 
Join Date: Apr 2009
Location: Mumbai
Posts: 647
Thanks: 95
Thanked 73 Times in 57 Posts
Rep Power: 2 |
Re: The Mystery of Scott/Tiger in OracleQuote:
Is it used to asign the default database alias?
__________________
Nimesh aka KFP My Blog | My Moments | My Profile Save Time Effortlessly OR Spend Time Efficiently. The Choice Is Yours |
|
|
|
|
 |
|
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
| Bookmarks | |
Linear Mode
|
|
|
|
||||||||||||||||||||||||||||||||||||
All times are GMT +5.5. The time now is 05:53 AM.