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

Nine Stars

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

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?

Thirteen Stars

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

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

-----------
Forteen Stars TRF
Forteen Stars

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