toraclebulkexec error ORA-00942 table or view does not exist

[Ajay3]

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

[manodwhb]

@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.

[Anonymous]

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-vie...

    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 🙂