Mixed case in table names

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

87 rows seleted.

If anyone has any ideas please let me know. Thank you. Received on Mon Aug 21 1995 - 00:00:00 CEST