Re: help needed: dropping tables with unusual names

literally take "Table_for_important_Information_concerning_Whatever" and put a drop table in front of it.

drop table "Table_for_important_Information_concerning_Whatever";

anytime access(or other tools) create table with lowercase characters, put the table name in " and it should work.

joe
http://www.oracle-dba.com

> "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 Thu May 21 1998 - 08:17:43 CDT