You are not logged in.
How can I help improve performance when loading data from a large source table beside using cursor? Can someone please give me an example? I got tip from using the tOracleOutputBulkExec and it seems to help in saving data to the target table.
Thanks so much.
You could use Oracle's spool command to dump the data to a flat file.
https://forums.oracle.com/forums/thread … p;#9963144
Last edited by phobucket (2012-05-22 21:52:41)