Page 1 of 1

Load XML file into a column in table

Posted: Fri Sep 17, 2010 12:12 pm
by Nagin
Hi,
I am trying to load an XML file into a Oracle table column. And, the XML files can be really big, they can go upto 10Gb.

This oracle table is more of a control table. It will have a row for each xml file received with Received timestamp and a unique id and other things populated

Any ideas how this can be done?

Thank you.

Posted: Mon Sep 20, 2010 3:33 am
by ArndW
With BLOBs that big I would use the bulk loader.