My Oracle Support Banner

ORA-4043 on Describe and ORA-942 Selecting from imported table using MS Access (Doc ID 272168.1)

Last updated on APRIL 09, 2020

Applies to:

Oracle ODBC Driver - Version 8.1.7.4.0 and later
Microsoft Windows (32-bit)

Symptoms

After importing a table from Microsoft Access into ORACLE using the Oracle ODBC Driver, user can see the table name exists by a "select table_name from user_table" command. 

However when you issue an "Desc tablename" for the new imported table, you see errors:

ORA-04043 :object employee does not exist. 

And, "ORA-00942: table or view does not exist" If a SELECT command is issued 

Changes

The table was imported improperly using Microsoft Access. 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.