desc of a existing table not possible

**kiltz** · 03-26-2002, 11:49 AM

dear fiends,

why is Oracle so cryticaly?!

On Oracle 8.0.5.0.0 I execute a SELECT statement to view the content of the table. But when I try to DESC the identical table it does not work. - Is´nt it cypticaly?

chris

**marist89** · 03-26-2002, 11:55 AM

What do you mean "It doesn't work". Do you get an error message?

**kiltz** · 03-26-2002, 12:39 PM

yes, the error message is: "table or view does not exist" :<

chris

**sambavan** · 03-26-2002, 12:45 PM

Describe is there in 8.0.5. Can you tell more on what you did and how you did?

Sam

**kiltz** · 03-26-2002, 01:27 PM

SQL*PLUS:
- I connectet as a user who got dba rights
- than I selected one table (the table is owned from this user)
- and now I try to descibe the table I selected before

that´s it!

chris

Jr · 03-26-2002, 01:40 PM

try to do
sql> desc "table_name"

within DOUBLE QUOTES.

Jr.

**ovidius** · 03-26-2002, 01:41 PM

Yes, so???!!!
I think I can't understand what hapens there... What is your problem, again?

**kiltz** · 03-26-2002, 01:44 PM

Hmm...

SQL>ORA-00942 table or view does not exist

chris

**marist89** · 03-26-2002, 01:50 PM

Lets see the output from :

Code:

SELECT owner, object_name, object_type
FROM dba_objects
WHERE upper(object_name) = upper('your_object_name')

Thread: desc of a existing table not possible

Thread Tools

Display

Posting Permissions