Re: Cannot drop the table

hi
let say your table name comes as "taBleName" in the user_tables view then use
drop table "taBleName";

You probably created table as case sensitive thats why oracle has not allowed you
to drop table with different name.

hope it works...

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 Mon Nov 23 1998 - 17:14:00 CST