Re: Load XML-File into Oracle

From: Jiang, Tony [WIC:2Y88:EXCH] <tony_jy_at_nortelnetworks.com>
Date: Fri, 16 Aug 2002 15:11:28 -0600
Message-ID: <ajjpg5$7r0$1_at_bcarh8ab.ca.nortel.com>


It depends on which way to go. If programming, it's easy to use any XML parser to generate the loader fiile. I have used Java Xerces or Microsoft DOM parser. They are quite convenient to use.

However, maybe you can find some good tool to finish the job easily.

"frank kloeck" <frank.kloeck.fk_at_bayer-ag.de> wrote in message news:a879f21b.0208160710.6306d091_at_posting.google.com...
> Hello,
>
> I want to store big data sets (200000 records and more) into an Oracle
> 8.1.7 database. I want to do it so fast as possible. Actual we do it
> with an oracle Loader file via direct path - this works fine. But the
> data provider switch now to XML. Has anyone experience (examples are
> great) what is the best way to transform XML to a Loader file. Can I
> handle this problem with a XLS style sheet or is a tool or program
> preferable.
>
> Thanks
> Frank
Received on Fri Aug 16 2002 - 23:11:28 CEST

Original text of this message