Re: Mixed case in table names

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.
>
>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
>
>
 rows seleted.
>
>If anyone has any ideas please let me know. Thank you.

We had the same problem with objects created with ERwin. What you need to do is enclose the tablename in double quotes.

eg: drop table "Test";

By default, the Oracle data dictionary stores everything in upper case. (I suppose that's why the Oracle export files put EVERYTHING in double quotes ... just in case you used Access or ERwin to create your tables!)

Hope this helps.

-- 
*******************************************************
Mike Morgan
Technology Integration Services - Unix DBA

email: Mike.Morgan_at_teldta.com

TDS Computing Services
301 S. Westfield Road
Madison, WI 53705  USA
(608)845-4661

"The DBA is always right ... even when [s]he's wrong."
*******************************************************