| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: help needed: dropping tables with unusual names
Manuel,
Something is wrong here. I just tried to do exactly as you described, and it *correctly* failed. I created a table in MS Access 97 called "Table_for_important_Information_concerning_Whatever", which worked.
Then I attempted to perform a File -> Save As/Export to an ODBC datasource to an Oracle8 database. It results in an Oracle error ORA-00972 "Identifier is too long", which is correct, because the table name that it is trying to use exceeds the maximum identifier length.
Trying this same CREATE TABLE statement in SQL*Plus also correctly fails with an ORA-00972 error.
Maybe the table name was truncated somehow when these users "exported" these tables from MS Access. I recommend accessing the Oracle database via SQL*Plus and looking at what Oracle has defined these table names as (e.g., SELECT table_name FROM user_tables). This way, you can find the names of the tables you wish to drop.
On Wed, 20 May 1998 16:12:23 GMT, 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
Thanks!
Joel
Joel R. Kallman Oracle Government, Education, & Health
Columbus, OH http://govt.us.oracle.com jkallman@us.oracle.com http://www.oracle.com
 |
 |