topic Re: toraclebulkexec error ORA-00942 table or view does not exist in Talend Studio

toraclebulkexec error ORA-00942 table or view does not exist

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

Hi All,

I am trying to use tOracleBulkExec component (TOS 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 also tried by using component tOracleBulkOutput and tOracleBulkOutputExec again I am facing the same error :

Exception in component tOracleBulkExec_1_t0BE
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist.

It work fine when I use tOracleOutput component, but since I have to update high volume of data and performance is the concern, cannot prefer using tOracleOutput.

I am able to query the table in the database. Not sure why I am getting this wired error.

Can anyone please assist.

Regards,

Ajay

Re: toraclebulkexec error ORA-00942 table or view does not exist

manodwhb — Tue, 05 Feb 2019 04:58:14 GMT

@Ajay , are you able to see the table other than talend like in SQL developer with same user,which you were using in talend? might be grant permissions not provided for that table.

Re: toraclebulkexec error ORA-00942 table or view does not exist

Anonymous — Tue, 05 Feb 2019 13:20:35 GMT

Hi Ajay,

I could see that you have raised multiple posts (link below) on same thread which is not the right way of using Talend community resources.

https://community.talend.com/t5/Design-and-Development/Error-tOracleBulkExec-component-table-and-view-does-not-exist/m-p/150033#M91737

Could you please keep only one post as open for a topic and close the duplicate one? We are happy to help you but posting the same query multiple times is almost equivalent to spamming. So select whichever post you want to pursue further and close the other one. If the other post has already answered your query, please close both posts. 🙂

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 🙂