unable to import data from oracle db

Question

Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [42S02] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist ,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [42S02] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist ,Source=msora28.dll,'

but table exists on the source side. I even tried to retrieve the data by hard coding but no luck. I verified connection string as well they are good and correct.

when I hard coded I got below error

Error code9602

Activity IDf790a26c-e620-49d4-b333-2ab316d5d05e

DetailsERROR [42S02] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist

Answer 1

The ORA-00942: table or view does not exist error can occur due to several reasons:

https://www.databasestar.com/ora-00942/

1. The statement references a table or view that does not exist.
2. You do not have access to the table or view.
3. The table or view belongs to a different schema, and you did not refer to the schema name.
4. You're using Oracle 12c, using a sequence as a default value, but don't have select privileges on the sequence

a few possible solutions you can try

• Check if the table exists

SELECT owner, object_name, object_type
FROM all_objects
WHERE object_type IN ('TABLE','VIEW')
AND object_name = 'YOUR_TABLE_NAME';

• Check the owner of the table
• Check your query
• Check sequence privileges

Please note that the Azure Data Factory Oracle connector is working with a regular username and password, but it can throw errors when using proxy user authentication. The connector might not validate additional connection properties, which could be a potential issue

https://learn.microsoft.com/en-us/answers/questions/876282/azure-data-factory-oracle-connector-proxy-user-aut

Lastly, there might be an issue with the schema of the table. If the table was created in the SYS schema, it might not be accessible unless you either prefix the table name with the schema or create a synonym in your schema for the table

https://dba.stackexchange.com/questions/47074/getting-ora-00942-table-or-view-does-not-exist-while-table-does-exist