I periodically have to get big chucks of XML – 100 to 300 MB – from database
CLOBs or BLOBs to flat files.
We (finally) moved from 9.7 to 10.5 recently, always behind as usual, and I’ve
started getting out-of-memory errors when I do that. Physical machine hasn’t
My normal approach probably hasn’t been the most efficient. With 9.7, I would
typically select the CLOB column for the record of interest and SaveAs, now
ExportData. On 10.5.1.3 that’s giving me the out-of-memory popup.
I’ve tried the ExportBlobs, but it just hangs. If I have a BLOB column, I can
open up the popup editor and save it without any trouble. But opening a 150 MB
CLOB with the popup editor just means sitting there for a day or so while it
tries to parse.
Before I generate my bundle and head over to support, any suggestions on
settings I should try? Some of mine might have gotten confused during our
James F. Hudson
Wisconsin Department of Natural Resources