Hi, There have been previous posts about writing large data files from database queries and I have the same problem. The files I need to create may be up to 200-300MB in size (csv). I haven't tried in off-peak time but when I tried a large queries during normal hours it got a memory error.
Does anyone know if there anyway to stream the results of a query which I can then write to a file? Java has been mentioned for the file write. Is there any way to stream the result of a query in java, ColdFusion or similar? One option is to write a file using PL/SQL but with the current secruity policies it looks to be a time consuming process to get the appropriate permissions in place. Cheers ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284482 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
