Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> help needed: dropping tables with unusual names
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