Re: HELP! (AKA Those whacky users...)
Date: 1995/12/08
Message-ID: <4a9mqn$7sn_at_punch.dot.state.ny.us>#1/1
In article <DJ8LJI.4JJ_at_twisto.eng.hou.compaq.com>,
Kim=Hughes%NA%Contractors_at_bangate.compaq.com says...
>
>Tim,
> Try enclosing the table name in double quotes.
>
>D. Kim Hughes
>DRT Systems International
>Houston, Tx 77008
>(713)868-5537 ext: 312
>
Thanks to all who responded via the service and email. The solution expressed
herein was pretty much the general consensus. So I tried it, using both
single- and double-quoted strings (ie: drop table "apparent_table_name ";).
The results were:
Single quotes: ORA-00903: invalid table name
Double quotes: ORA-00942: table or view does not exist
Interesting note - the messages returned by the single-quote attempt also
returned the quotes in the statement reiteration. The double-quote attempt
reiterated the statement with the quotes stripped out.
Is there maybe something in our SQL*Plus setup that's defeating the double
quote?!
I know this sounds messy, but has anyone attacked such a problem by DELETE-ing
FROM the underlying system tables using, say, rowid or some other 'back-door'
method?
Another interesting note (to me, anyway): The dump() function has revealed
that the trailing character is character 64. On the IBM VM, this would be
EBCDIC 64, or hex 40, or a space, or so I'm told. Maybe I've got the wrong
'space'?!
Thanks again, and if anyone has any other (fit to print) suggestions, I'm
listening!
Tim. Received on Fri Dec 08 1995 - 00:00:00 CET