toraclebulkexec error ORA-00942 table or view does not exist

Four Stars

toraclebulkexec error ORA-00942 table or view does not exist

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

Forteen Stars

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

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Employee

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

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 :-)

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch