Home » SQL & PL/SQL » SQL & PL/SQL » problem with table ....help
problem with table ....help [message #266684] Tue, 11 September 2007 07:17 Go to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
hello friends

I have a table in my schema , when i issue this query


SQL> select object_name,status, temporary,object_type from user_objects where o
bject_name like 'TEMP%';

OBJECT_NAM STATUS T OBJECT_TYPE
---------- ------- - -------------------
TEMP_AMMAR VALID N TABLE
TEMP_AMMAR VALID N TABLE
1

TEMP_AMMAR VALID N TABLE
123

TEMP_JOB_M VALID N INDEX
OD_PK


But when i issue this

SQL>
SQL> desc TEMP_AMMAR;
ERROR:
ORA-04043: object TEMP_AMMAR does not exist


SQL>

I am unable to understand this , can you please show me thing.I want data in this table.

Thanking YOU
Re: problem with table ....help [message #266698 is a reply to message #266684] Tue, 11 September 2007 07:56 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
I have just gone cross-eyed reading this post. Please read the forum rules on how to post a message properly.

Enough with being a stubborn ass - you have been asked in almost every one of your posts to follow the guidelines and you still haven't.

[Updated on: Tue, 11 September 2007 08:01]

Report message to a moderator

Re: problem with table ....help [message #266707 is a reply to message #266684] Tue, 11 September 2007 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You still don't want to follow the guidelines, you still don't have help from me.

http://www.orafaq.com/forum/mv/msg/89099/266641/102589/#msg_266641

Regards
Michel
Re: problem with table ....help [message #266712 is a reply to message #266684] Tue, 11 September 2007 08:22 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
You refuse to make your posts readable then
YOYO (Your on your own)
Re: problem with table ....help [message #266916 is a reply to message #266712] Wed, 12 September 2007 00:16 Go to previous message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
I apologise for my repeated mistakes.

Actually friends , in my schema when i issue first query it shows me tables TEMP_AMMAR, TEMP_AMMAR1 .But when i try to describe those tables or try to access those , it gives me the error object does not exists.
What is the reason i do not understand.

Please Help me.

[Updated on: Wed, 12 September 2007 00:23]

Report message to a moderator

Previous Topic: Finding locking Information
Next Topic: How to unify a query so that it would work on both Oracle and MS SQL Server? (merged b
Goto Forum:
  


Current Time: Sat Dec 10 22:27:12 CST 2016

Total time taken to generate the page: 0.06584 seconds