Drop Database called "User" from Oracle

Ok this is what happend...

One of my colleges run a script that created some tables which included one table called "User" on an Oracle XE 10g. Now we are unable to drop that table, we get an ORA-00903 every time we run a:

DROP TABLE USER CASCADE CONSTRAINTS

The same happens when ever we try to run any alter query on it (that means renaming doesn't work)

Do someone know开发者_如何学编程 how to deal with this?

---

have you tried fully qualifying with quotes:

drop table "myschema"."user"

---

Randy is right suggesting quoted identifiers. Note however that quoted identifiers are case-sensitive.

First, query ALL_TABLES or USER_TABLES to find the case-sensitive name of that table, and use that name in a statement such as

DROP TABLE "User";

or

ALTER TABLE "User" RENAME TO TBL_USERS;