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 and later
Microsoft Windows (32-bit)


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 


The table was imported improperly using Microsoft Access. 


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.