Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 247253 - Last Review: December 5, 2003 - Revision: 4.1
PRB: Error Importing an Oracle Table in Access 2000 When Tablename Contains Lower Case Letters in USER_OBJECTS System Catalog
This article was previously published under Q247253
The error message:
ORA-00942: table or view does not exist
will be seen when trying to access a table which was exported from Access 2000 using MSORCL32.DLL and the destination table is not specified using upper case letters.
By Default Oracle stores the names of database objects and other schema information in upper case in its system catalogs. When an Access 2000 table is exported using Msorlc32.dll, the table is created on the Oracle server and the table name is stored in exactly the same way as specified during
the export process. Specifying table names using lower case letters results in problems because in this case the table name is stored differently compared to the default storage pattern.
Specify the name of the destination table using upper case letters when exporting a table from an Access 2000 database to an Oracle Server.
This behavior is by design.
This problem is seen because of the way in which Oracle internally stores schema information.
Steps to Reproduce Behavior
Create a system DSN using Msorcl32.dll version 2.573.4202 which connects successfully to an Oracle 8.0.5 server.
Create a table in Access 2000 and try to export this table to the Oracle 8.0.5 server using the system DSN created in step 1. When asked to specify the destination table name use a combination of lower and upper case letters or just lower case letters.
Connect using SQL*PLUS or any other oracle client utility and then run the following query "Select object_name from user_objects". It is seen that the table name in the system catalog appears similar to the name specified for the destination table during the export process. All the other object names appear in upper case.
Try importing the table from Access 2000 using the system DSN created in step 1.Errors are seen indicating that such a table doesn't exist in the schema.
APPLIES TO
- Microsoft Open Database Connectivity 2.5
- Microsoft Open Database Connectivity 2.5
- Microsoft Open Database Connectivity 2.5
- Microsoft Data Access Components 2.5
- Microsoft Data Access Components 2.6
- Microsoft Data Access Components 2.7
| kbdatabase kbdriver kboracle kbprb KB247253 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
James Bayly
- jbayly2 NOSPAM-AT-NOSPAM jaguar.com
|
Reported as Irrelevant
|
| Written:
5/24/2005 3:45 AM |
|
|