Use of toracleBulkExec for Job Performance Optimization

[abhi90]

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 

[vapukov]

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

[abhi90]

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?

[vapukov]

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

[abhi90]

Hi @xdshi, @shong,

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