Hi everyone,

I exported some tables from a MSSQL Server database using the DTS package and a Microsoft ODBC Driver for Oracle.
The tables structure and data was moved without any complaints to the Oracle 8i database (on Windows 2000 Server), but when I tried to query them I got the "ORA-00942: table or view does not exist" error message, despite the fact that the tables exist.

I can see the tables and their content in DBA Studio: they are OK. The tables and views are in the data dictionary also.

When I try to describe them I got the error: ORA-04043: object does not exist.

I researched on the Internet and noticed that this behavior is not new, but I didn't find a solution there.

Does anybody know why this problem happens and how to get around it?

Thanks in advance,

Paul