Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> help needed: dropping tables with unusual names

help needed: dropping tables with unusual names

From: Manuel Schueren <schueren_at_mpi-fg-koeln.mpg.de>
Date: Wed, 20 May 1998 16:12:23 GMT
Message-ID: <3562fda0.11032644@news.mpi-fg-koeln.mpg.de>


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 Received on Wed May 20 1998 - 11:12:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US