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
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.
can you please check above
The Oracle error "ORA-00942: table or view does not exist" is quite common error when one of the below issue happens.
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?
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 :-)
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.