Re: Mixed case in table names
Date: 1995/08/21
Message-ID: <karsten.54.0015DC36_at_pip.dknet.dk>#1/1
In article <41a55b$rgj_at_triton.unm.edu> quanta23_at_unm.edu (Mr. Potato Spud Head) writes:
>From: quanta23_at_unm.edu (Mr. Potato Spud Head)
>Subject: Mixed case in table names
>Date: 21 Aug 1995 08:27:55 -0600
>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.
>This is an example of what I tried and the result:
>SQL> drop table Test;
>drop table Test
> *
>ERROR at line 1:
>ORA-00942: table or view does not exist
>I know that the table is there because I can attach to it through
>Access. Also it is listed in all_tables. Example:
>SQL> Select table_name from all_tables;
>TABLE_NAME
>-----------------------------------
>PROVIDER
>TPA
>CLAIM
>JURISDICTION
>AUDIT_ACTIONS
>Test
>If anyone has any ideas please let me know. Thank you.
Try use:
I've not tested this command, but I think it will work:
Drop table "Test";
(The quotes are important)
Karsten Weikop (Email: karsten_at_pip.dknet.dk) PBJ Consult A/S
Roholmsvej 10G
DK-2620 Albertslund
Denmark
Phone: + 45 43 62 74 00
Fax..: + 45 43 62 74 24
Received on Mon Aug 21 1995 - 00:00:00 CEST