Hi ,
Can you please share code with me. We have similar problem to move large set oracle to DWH as csv files. We used PL/SQL procedure , but we faced the issue like temp table space exceed.

If possible please share the code for data movement.That will be more helpfull to me

Mah@rac