Error : tOracleBulkExec component table and view does not exist

Four Stars

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

Seven Stars

Re: Error : tOracleBulkExec component table and view does not exist

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.


Regards
Abhishek KUMAR
( Please mark the post as resolved if you found your solution )
Seven Stars

Re: Error : tOracleBulkExec component table and view does not exist

can you please check above 

Regards
Abhishek KUMAR
( Please mark the post as resolved if you found your solution )
Highlighted
Employee

Re: Error : tOracleBulkExec component table and view does not exist

Hi,

 

    The Oracle error "ORA-00942: table or view does not exist" is quite common error when one of the below issue happens.

 

  1. Referencing a table or view that does not exist
  2. Using an unauthorized synonym
  3. Using an expression of view where a table is required
  4. 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 :-)


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.