Re: help needed: dropping tables with unusual names

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 20 May 1998 18:19:06 GMT
Message-ID: <35641e1c.14559896@192.86.155.100>

A copy of this was sent to schueren_at_mpi-fg-koeln.mpg.de (Manuel Schueren) (if that email address didn't require changing) On Wed, 20 May 1998 16:12:23 GMT, you 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

Use quoted identifiers.

SQL> create table "select * from emp" ( "delete from dept" int ); Table created.

SQL> select * from cat where table_name like 's%';

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
select * from emp              TABLE

SQL> select * from "select * from emp"; no rows selected

SQL> drop table "select * from emp";
Table dropped.

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed May 20 1998 - 13:19:06 CDT