Cannot drop the table

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 - 02:21:40 CST