Use of toracleBulkExec for Job Performance Optimization

Eight Stars

Use of toracleBulkExec for Job Performance Optimization

Hi All,

 

Have anyone successfully implemented toracleBulkexec if the Database is rds? My Database is hosted in rds and connection string is xxxx.rds.amazonaws.com. My Datafile is generating perfectly in my Local. But when it is entering in toraclebulkexec it is throwing an error 

SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]

I have tested toraclebulkexec in my Home Laptop where I am using sql developer which improves performance a lot. If any suggestions Please let me know 

 

Thirteen Stars

Re: Use of toracleBulkExec for Job Performance Optimization

with AWS(RDS) - always something different compare to dedicated server

 

for each tBulk components - file must be local for database (located on same server with Oracle)
https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/E~fTfv77DEMgwnN891mP_g

 

You need more check about Import/Export for Oracle on RDS, and may be implement different solution:

- export data to EC2

- use command to import data
read more - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html

-----------
Eight Stars

Re: Use of toracleBulkExec for Job Performance Optimization

Hi @vapukov,

Thanks for your reply. actually We are doing our Project Development Works in Open Studio. Don't have EC2 Now. Can You tell me where should I create my Data File?

Thirteen Stars

Re: Use of toracleBulkExec for Job Performance Optimization

with this question - could not help, because I have not Oracle on RDS

-----------
Eight Stars

Re: Use of toracleBulkExec for Job Performance Optimization

Hi @xdshi@shong,

Can You please suggest on here where I can create the Datafile