desc command does not work

Printable View

03-08-2002, 05:26 AM
kiltz

hi !

the select command works but if I try the desc command on the same object it does not work.

Does any body know the reason why?

Thank you in advance,

chris
03-08-2002, 05:34 AM
mzahid

Desc table

Do you own the object you are trying to run desc on?
03-08-2002, 06:46 AM
kiltz

Yes!
03-08-2002, 06:50 AM
aarroyob

In which utility are you using the desc command. This command is specific of SQL*Plus.

Regards

Angel
03-08-2002, 07:04 AM
kiltz

I´m using "golden view" but I think that is not the problem... because it is working on the other data bases...

Is there a special role allowing to read such information?

chis
03-08-2002, 07:30 AM
rswamin

golden view

what is that golden view . is it a tool. where can i get more details about that. is there any download available for that.
pls inform.

regards

swaminathan
03-08-2002, 08:00 AM
kiltz

golden view from benthic software

you can download a 30 days trial version here:

http://www.benthicsoftware.com/downloads.html

chris
03-08-2002, 10:23 AM
fraze

What version of Oracle are you running (and which platform). We recently hit a simialr problem on 8.1.7 on AIX - it turned out to be a bug. Do you get an Oracle error no?
03-08-2002, 10:29 AM
marist89

Are you trying to describe a table across a database link? There have been problems with this as well.
03-08-2002, 10:52 AM
kiltz

Quote:

Originally posted by fraze
What version of Oracle are you running (and which platform). We recently hit a simialr problem on 8.1.7 on AIX - it turned out to be a bug. Do you get an Oracle error no?

I use Oracle 8.1.7 - so it is a bug?

The error is "table or view does not exist".
03-08-2002, 11:01 AM
kiltz

Quote:

Originally posted by marist89
Are you trying to describe a table across a database link? There have been problems with this as well.

No, I do not try this.

chris
03-08-2002, 11:07 AM
irehman

connect to DB from SQL*PLUS then describe the object see what happens.
03-08-2002, 11:37 AM
salamwahab

hi ,
first of all tell me,do u want to desc the cammand or the object if u want to desc the object and it is in ur scheme then just type
DESC table emp ;
and if u what to desc the cammand so start the EXPLAIN cammand and then rerun the cammand
03-08-2002, 11:43 AM
fraze

Doesnt sound like a the bug we were hitting. Is the table owned by the same user that you are doing the desc as. If not then you have to do to desc . or you can create a public synonym for that table as sys or system:

create public synonym for .;

03-08-2002, 11:48 AM
fraze

Quote:

Originally posted by fraze
Doesnt sound like a the bug we were hitting. Is the table owned by the same user that you are doing the desc as. If not then you have to do to desc . or you can create a public synonym for that table as sys or system:

create public synonym for .

;
Post didnt come out correctly. Should read

Doesnt sound like a the bug we were hitting. Is the table owned by the same user that you are doing the desc as. If not then you have to do to desc as. if not then you have to do

desc OWNER.TABLE_NAME

or create a public synonym for the table:

create public synonym TABLE_NAME for OWNER.TABLE_NAME;

All times are GMT -4. The time now is 12:06 AM.