Home » Other » General » EMP TABLE IN ORACLE 10G (VISTA)
EMP TABLE IN ORACLE 10G [message #355215] Thu, 23 October 2008 02:54 Go to next message
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....
Re: EMP TABLE IN ORACLE 10G [message #355232 is a reply to message #355215] Thu, 23 October 2008 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: EMP TABLE IN ORACLE 10G [message #355550 is a reply to message #355215] Sat, 25 October 2008 02:40 Go to previous messageGo to next message
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.
Re: EMP TABLE IN ORACLE 10G [message #355556 is a reply to message #355550] Sat, 25 October 2008 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: EMP TABLE IN ORACLE 10G [message #355562 is a reply to message #355556] Sat, 25 October 2008 06:26 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Smile

[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 Go to previous messageGo to next message
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)
Re: EMP TABLE IN ORACLE 10G [message #400160 is a reply to message #355215] Sun, 26 April 2009 14:57 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
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.
Re: EMP TABLE IN ORACLE 10G [message #400309 is a reply to message #400157] Mon, 27 April 2009 08:30 Go to previous messageGo to next message
joy_division
Messages: 4515
Registered: February 2005
Location: East Coast USA
Senior Member
And who said anything about User Does Not Exist.
Re: EMP TABLE IN ORACLE 10G [message #403947 is a reply to message #355215] Tue, 19 May 2009 14:45 Go to previous messageGo to next message
djbabu
Messages: 14
Registered: May 2009
Junior Member


haha,

I like this post.!
Re: EMP TABLE IN ORACLE 10G [message #404004 is a reply to message #403947] Wed, 20 May 2009 00:56 Go to previous messageGo to next message
Frank
Messages: 7877
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?!
icon10.gif  Re: EMP TABLE IN ORACLE 10G [message #404231 is a reply to message #404004] Thu, 21 May 2009 01:08 Go to previous messageGo to next message
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
Re: EMP TABLE IN ORACLE 10G [message #404250 is a reply to message #404231] Thu, 21 May 2009 02:12 Go to previous messageGo to next message
Littlefoot
Messages: 19630
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.
Re: EMP TABLE IN ORACLE 10G [message #404264 is a reply to message #400157] Thu, 21 May 2009 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: EMP TABLE IN ORACLE 10G [message #404417 is a reply to message #404231] Thu, 21 May 2009 13:57 Go to previous messageGo to next message
Frank
Messages: 7877
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.
Re: EMP TABLE IN ORACLE 10G [message #404451 is a reply to message #404231] Thu, 21 May 2009 20:01 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
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:
  


Current Time: Sun Sep 21 17:29:02 CDT 2014

Total time taken to generate the page: 0.22142 seconds