Load XML file into a column in table

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Nagin
Charter Member
Charter Member
Posts: 89
Joined: Thu Jan 26, 2006 12:37 pm

Load XML file into a column in table

Post 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.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

With BLOBs that big I would use the bulk loader.
Post Reply