Re: Can't describe table!

Will Kooiman, kooiman_at_interserv.com wrote:

>> chuckh_at_ix.netcom.com (Chuck Hamilton) writes:
>> There's a table in my Oracle 7.1 database with a lower case name. I
>> can access the table just fine by enclosing the name in double quotes,
>> but I can't DESCRIBE it to see the column names. How to I specify a
>> lower case table name in a DESCRIBE command?
>>
>> I thought about renaming it to upper case but I really don't want to
>> do that.
 

>Have you tried defining a synonym that points to the table?

Tried this too. I said ...

create synonym CASHDIS for "cashdis";

This worked fine. But when I tried to do "desc cashdis", SQL*Plus hung. I had to kill it. I think it got stuck in some kind of loop.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!