topic Re: Error : tOracleBulkExec component table and view does not exist in Talend Studio

Error : tOracleBulkExec component table and view does not exist

Ajay3 — Sat, 16 Nov 2024 06:41:28 GMT

Hi All

I am trying to use tOracleBulkExec component (6.3) to "UPDATE" an Oracle table from a .csv file

I am getting the following error:
Exception in component tOracleBulkExec_1_t0BE
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

I tried using tOracleOutputBulk and tOracleOutputBulkExec but still Iam getting the same error

I tried using tOracleOutput component its is working fine. but since I have to update large volume of data and performance is the concern, cannot prefer doing via tOracleOutput

Can anyone please assist

Re: Error : tOracleBulkExec component table and view does not exist

akumar2301 — Sun, 03 Feb 2019 18:33:44 GMT

check if you have Create table permission in the schema ? you must have create table permission to do Update mode operation.

Also check if same job works in "append" mode instead of update ? if all ok it means no issue with your job design and above is only reason you have this issue.

Let me know if you are able to identify issue.

Re: Error : tOracleBulkExec component table and view does not exist

akumar2301 — Tue, 05 Feb 2019 06:42:24 GMT

can you please check above

Re: Error : tOracleBulkExec component table and view does not exist

Anonymous — Tue, 05 Feb 2019 13:06:47 GMT

Hi,

The Oracle error "ORA-00942: table or view does not exist" is quite common error when one of the below issue happens.

Referencing a table or view that does not exist
Using an unauthorized synonym
Using an expression of view where a table is required
Attempting to use a table without proper permission or privilege

Since you have told that you were able to do the operation with tOracleOutput, could you please advise the Table operation you selected in the component? If there is privilege issue, you would not have been able to create the table if not available already.

Another quite common mistake which I used to do when I was a developer is to use wrong user id to do the operation where table will not be available. There is high chance that table will be under separate user/schema. Could you please look these issues and come back?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂