Re: Cannot drop the table

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 22 Nov 1998 17:31:57 GMT
Message-ID: <365c4752.11512472@netnews.worldnet.att.net>

On Sun, 22 Nov 1998 16:21:40 +0800, Joe <joetin_at_netvigator.com> wrote:

>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.

You'll need to quote table name when dropping it, because it's mixed-case. From SQL*Plus:

SQL> DROP TABLE "FaxQueue"

Be sure to use double-quotes, " not '.

>Could someone help me: 1) to drop the tables, 2) how to create the
>"normal " table in
>Oracle Database through Access or ODBC.

You did create a normal table, but life might be easier if you stuck to uppercase-only. Oracle will always uppercase table names unless they are quoted. FWIW, I would avoid table names with embedded spaces too.

regards,

Jonathan Received on Sun Nov 22 1998 - 11:31:57 CST