Re: Cannot drop the table

Oracle doesn't really support mixed case object names in an easy way. You need to enclose the objectname by " to get it working. The statement drop table "FaxQueue";

should drop the table without problems. AFAIK the only way to prevent this problem is: if you create tables through ODBC use uppercase only, if you migrate Access tables, convert their names to uppercase (access will not object) before you migrate them to Oracle.

Hth,

Sybrand Bakker, Oracle DBA

Joe wrote:

> I setup the testing environment that uses Access 97 to access the Oracle
> 7.3 Server in HP-UX
> through ODBC (supplied by Oracle). When I created the table through
> ODBC, it succeeded.
> But when I tried to drop the table, it failed. The return string is
> "Table or view not found".
>
> When I logged in the Oracle Database in Unix, I could find the table
> name in the "user_tables" but
> the name shown is "FaxQueue" (in both upper and lower cases). When I
> tried to drop the
> table in sqlplus/server manager, the error message, "Table or view does
> not exist", appeared.
>
> Could someone help me: 1) to drop the tables, 2) how to create the
> "normal " table in
> Oracle Database through Access or ODBC.
>
> Thanks in advance.
>
> Joe Tin
> joetin_at_netvigator.com

Received on Sun Nov 22 1998 - 04:59:55 CST