Re: Mixed case in table names

From: <ericl_at_community.net>
Date: 1995/08/23
Message-ID: <41f94r$s1j_at_odin.community.net>#1/1


In article <41a55b$rgj_at_triton.unm.edu>,

   quanta23_at_unm.edu (Mr. Potato Spud Head) wrote:

>I created a table by exporting it from an Access database to Oracle7. The
>table was named 'Test' typed with a capital T and the rest of the letters
>lower case. I can't select from or drop this table from the Oracle
>database.
>I know that the table is there because I can attach to it through
>Access. Also it is listed in all_tables. Example:
>If anyone has any ideas please let me know. Thank you.

You might try puttijng double quotes around the table name i.e.

drop table "Test"

Good Luck

Eric Received on Wed Aug 23 1995 - 00:00:00 CEST

Original text of this message