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

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

talendtester — Thu, 10 May 2018 22:36:50 GMT

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?

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

vapukov — Sat, 12 May 2018 12:10:34 GMT

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

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

TRF — Sat, 12 May 2018 12:48:52 GMT

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-using-custom-SQL/td-p/97086