Oracle - How to export faster when you can't install on the DB server?

[talendtester]

When you have an Oracle database and you don't have permissions to install software on the database server, what is the best approach for being able to quickly pull out 9 million rows of data? Right now its taking over 4.5 hours using tOracleInput.

The DBA tells me data pump is installed on the database server.

I created an external table with 3 .dmp files, I see data was written into the files. Is there a way Talend can read the data out of the .dmp files?

[vapukov]

You can use combination of 3 components:

- tOracleBulkOutput - https://help.talend.com/reader/OrVKY3aU49Xb35rRrikPTA/HfKcPUJ6JDScazgvN9q5fg

- transfer (tSCP ot tFTPPut) to Oracle server local folder

- tOracleBulkExec - https://help.talend.com/reader/OrVKY3aU49Xb35rRrikPTA/cJCqFax52pAkMsnilGVGWA

[TRF]

Did you try the options proposed by @rhall here?
https://community.talend.com/t5/Design-and-Development/Oracle-What-is-the-best-way-to-bulk-export-us...