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.
↑ Back to the top
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.
↑ Back to the top
Specify the name of the destination table using upper case letters when exporting a table from an Access 2000 database to an Oracle Server.
↑ Back to the top
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.
↑ Back to the top