
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Error : tOracleBulkExec component table and view does not exist
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can you please check above

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 🙂
