Re: help needed: dropping tables with unusual names

In default all oracle objects names are in uppercase. If you want to use case sensitive object names you have to place this object names in "". For example you want to create a table Important New with the column This is the text you have to do the following things: 1.
CREATE TABLE "Important News" ("This is the Text" VARCHAR2(2000)); 2.
INSERT INTO "Important News" VALUES('All Statements referencing the table have to use ""');
3.
SELECT "This is the text" FROM "Important News"; 4.
DROP TABLE "Important News";

In article <3562fda0.11032644_at_news.mpi-fg-koeln.mpg.de>,   schueren_at_mpi-fg-koeln.mpg.de (Manuel Schueren) wrote:
>
> Hi!
> I have a problem. Some users exported tables fom MS Access to ORACLE7.
> They used tablenames they've given to the tables in Access, "Table for
> important Information concerning Whatever" for example.
> Now when they select the table_names from the user_catalog, they see
> the table like this:
> "Table_for_important_Information_concerning_Whatever".
> But trying to use any kind of statement on the table, ORACLE answers
> with "table or view does not exist".
> It is also impossible to drop this crap! Is there a wy to handle this
> problem?
> Thanks in advance,
>
> Manuel Schueren
>
> Max-Planck-Institut fuer Gesellschaftsforschung
> Cologne, Germany
>
> ms_at_mpi-fg-koeln.mpg.de
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 22 1998 - 00:57:13 CDT