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 188.8.131.52.0 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!