OraFAQ Forum: General » EMP TABLE IN ORACLE 10G

Home » Other » General » EMP TABLE IN ORACLE 10G (VISTA)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EMP TABLE IN ORACLE 10G [message #355215]

Thu, 23 October 2008 02:54

vijit_singhal99
Messages: 1
Registered: October 2008
Location: AA

Junior Member

PLEASE TELL HOW TO OPEN EMP TABLE IN ORACLE 10G....

WHEN I WRITE SELECT * FROM EMP;

IT SAYS TABLE DOES NOT EXIST....

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #355232 is a reply to message #355215]

Thu, 23 October 2008 03:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't post in UPPER case.

Creation script is $ORACLE_HOME/rdbms/admin/scott.sql or $ORACLE_HOME/sqlplus/demo/demobld.sql

Regards
Michel

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #355550 is a reply to message #355215]

Sat, 25 October 2008 02:40

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

It generally exists in SCOTT schema.

From which schema are you tring to execute this query?

Regards,
Dipali.

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #355556 is a reply to message #355550]

Sat, 25 October 2008 03:49

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Dipali Vithalani wrote on Sat, 25 October 2008 09:40

It generally exists in SCOTT schema.

From which schema are you tring to execute this query?

Regards,
Dipali.

Of course, only if SCOTT schema exists!

Regards
Michel

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #355562 is a reply to message #355556]

Sat, 25 October 2008 06:26

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

[Updated on: Sat, 25 October 2008 06:46]

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #400157 is a reply to message #355215]

Sun, 26 April 2009 14:10

NagRam01
Messages: 2
Registered: April 2009
Location: bangalore, India

Junior Member

I am not sure why you are getting the error "User doesnot exists". By default Oracle 10G posses "scott" user, may be the 'tab' on which you searched is wrong. Please follow the steps given below to check whether 'scott' user exists in schema.
connect sys/oracle as sysdba;
select username from all_users;
Check whether the 'scott' user exists.
If the user exists, you have to UNLOCK the 'scott' user. Else you have to create and load the script for user & table (check in google, how to create user and load default tables like 'emp', 'dept' and so on.

In 10g the test users accounts are locked by default.
Oracle has done this for security reasons. But you can unlock the account by login as sysdba.
SQL> connect sys/oracle as sysdba;
Connected.
SQL> alter user scott account unlock;
User altered.
Now exit the SQL* plus command prompt and launch it once again with scott/tiger.
It will say password expired and you may have to provide new password.
Just remember the new password(for eg: tiger01)

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #400160 is a reply to message #355215]

Sun, 26 April 2009 14:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

NagRam01,
I am not sure why you are responding to a post that is more than 6 months old as your first post on this forum.

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #400309 is a reply to message #400157]

Mon, 27 April 2009 08:30

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

And who said anything about User Does Not Exist.

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #403947 is a reply to message #355215]

Tue, 19 May 2009 14:45

djbabu
Messages: 14
Registered: May 2009

Junior Member

haha,

I like this post.!

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #404004 is a reply to message #403947]

Wed, 20 May 2009 00:56

Frank
Messages: 7901
Registered: March 2000

Senior Member

djbabu wrote on Tue, 19 May 2009 21:45

haha,

I like this post.!

Post count: 1

Did you really bother to register, just to be able to post this?!

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #404231 is a reply to message #404004]

Thu, 21 May 2009 01:08

NagRam01
Messages: 2
Registered: April 2009
Location: bangalore, India

Junior Member

"Hi" to all those who replied for my post.

I was just waiting yet to see how many replies I will get for my post Laughing

If you think I replied to a question which was posted before 5-6 months and if you think its waste of time, dont you think you are also wasting your time by replying to my post? Mad

I was searching for solution to my query in google and I got this Forum link and the above topic(EMP TABLE IN ORACLE 10G), as none of the posts were complete, I replied to this post keeping in mind, atleast some one in future who get this Forum link in google search may get complete answer.

I would request you all to make use of this forum to really discuss about some useful stuff(ONLY TECHNICAL) and not to comment on some technical post just to show how great you are... Sad

Dont type 'something' just to increase your 'post count' Shocked

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #404250 is a reply to message #404231]

Thu, 21 May 2009 02:12

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If I were you, I wouldn't worry about it. If site owner thought that questions asked six (or ten or eighteen or ...) months ago should not be discussed, he'd probably make sure that the Forum engine automatically locks such threads. As this is not the case, feel free to answer any question you like.

I hope you'll enjoy your stay here.

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #404264 is a reply to message #400157]

Thu, 21 May 2009 02:43

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

By default Oracle 10G posses "scott" user

This is not true. It includes SCOTT only if you put it or use dbca with default database model.

Regards
Michel

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #404417 is a reply to message #404231]

Thu, 21 May 2009 13:57

Frank
Messages: 7901
Registered: March 2000

Senior Member

NagRam01 wrote on Thu, 21 May 2009 08:08

I would request you all to make use of this forum to really discuss about some useful stuff(ONLY TECHNICAL) and not to comment on some technical post just to show how great you are... Sad

Dont type 'something' just to increase your 'post count' Shocked

I think you are taking quite a stance for someone that just joined. I don't know if you are aware of the habits in internet fora, but in most fora I know, people don't really like it if you "wake the zombies" (i.e. respond to really old, sleeping posts).
This means that if you choose to do so, you should be prepared for some remarks about it. If such remarks follow, read 'm & swallow them, but don't respond in the way you did.

Just my 2 cents.

Report message to a moderator

Re: EMP TABLE IN ORACLE 10G [message #404451 is a reply to message #404231]

Thu, 21 May 2009 20:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

@NagRam01,

If you are interested and willing to provide a solution to an older problem perhaps you should use my often asked "Have you solved your problem?" response and then if the Original Poster (OP) DOES reply, you give the answer.

David

Report message to a moderator

Previous Topic:	Update Query Working very slow
Next Topic:	How can I get the info on tables and columns and their data types.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 04:28:20 CST 2024